FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Related questions
Concept explainers
Question
Transcribed Image Text:Print Item
Navigator sells GPS trackers for $60 each. It expects sales of 5,700 units in quarter 1 and a 5% increase each subsequent quarter for the next 8 quarters.
Prepare a sales budget by quarter for the first year. Round final answers to nearest whole dollar.
Navigator
Sales Budget
For the Year Ending Dec. 31, 20XX
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Total
Expected Sales (Units)
Sales Price per Unit
Total Sales Revenue
Feedback
Check My Work
Increase the expected sales amount each quarter by 5%.
Previous
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Data Trevor Cycles manufactures chainless bicycles. On March 31, Trevor Cycles had 206 bikes in inventory. The company has a policy that the ending inventory in any month must be 20% of the following month's expected sales. Trevor Cycles expects to sell the following number of bikes in each of next four months: View the data. Prepare a production budget for the second quarter, with a column for each month and for the quarter. Trevor Cycles Production Budget For the Months of April through June April.. 1,030 bikes April May June Quarter May 1,170 bikes les 1030 1170 1390 1270 206 234 278 254 June.. 1,390 bikes esired ending inventory July 1,270 bikes eeded 1236 1404 1668 4308 206 206 234 646 Beginning inventory 1030 1198 1434 3662 o produce Print Donearrow_forwardSunland Company estimates its sales at 180000 units in the first quarter and that sales will increase by 17000 units each quarter over the year. They have, and desire, a 25% ending inventory of finished goods. Each unit sells for $25. 40% of the sales are for cash. 70% of the credit customers pay within the quarter. The remainder is received in the quarter following sale. Cash collections for the third quarter are budgeted at O $5273500. O $3026500. O $4387000. O $6057389.arrow_forwardAusten Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each quarter of the upcoming year are as follows: Austen anticipates selling 222,000 jars with total sales revenue of $267,000 in the first quarter of the year following the year given in the preceding table. Austen has a policy that the ending inventory of jars must be 30% of the following quarter's sales. Total sales Number of jars revenue sold Requirement Prepare a production budget for the year that shows the number of jars to be produced each quarter and for the year in 1st quarter.... $ 185,000 152,500 total. 2nd quarter $ 211,000 180,500 3rd quarter 2$ 257,000 210,000 4th quarter $ 193,000 160,000 ..... Prepare the production budget by first calculating the total units needed, then calculate the units to produce. Austen Foods Production Budget For the Quarters in the Upcoming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Unit sales Plus: Desired ending inventory Total needed Less:…arrow_forward
- Omegon Limited has the following sales forecasts for its watches next year:First Quarter..10,000 unitsSecond Quarter.5% increase over first quarterThird Quarter 3% increase from second quarterFourth Quarter.8% increase over third quarterWhat is Omegon’s total sales budget in units for next year?1) 43,485 units.2) 42,995 units.3) 40,685 units.4) 40,000 unitsarrow_forwardNavigator sells GPS trackers for $60 each. It expects sales of 5,200 units in quarter 1 and a 5% Increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year. Round final answers to nearest whole dollar. Navigator Sales Budget For the Year Ending Dec. 31, 20XX Quarter 1 Quarter 2 Quarter 3 Quarter 4 8 Expected Sales (Units) Sales Price per Unit Total Sales Revenue Totalarrow_forwardJoAnn Manufacturing has projected the following sales for the coming year: Sales $25,847.50 C$25,182.50 $22,604.17 Q1 $23,560.83 Q2 $ 54,750 $ 61,850 Q3 The company places orders each quarter that are 35 percent of the following quarter's sales and has a 30-day payables period. What is the payment of accounts for the third quarter? $70,050 Q4 $75,750arrow_forward
- Whispering Winds Company estimates that unit sales will be 10,500 in quarter 1; 12,600 in quarter 2; 13,800 in quarter 3; and 17,800 in quarter 4. Management wants to have an ending finished goods inventory equal to 21% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first six months of 2022. WHISPERING WINDS COMPANY Production Budget For the Six Months Ending June 30, 2022 Quarter 1 2 Totalarrow_forward2. Expected quarterly unit sales for tents at Sandy's Camping Gear are 7,500, 8,800, 3,200, and 2,900 for the next 2 years. At the start of the current year, inventory of finished tents on hand is 750 tents. Sandy's has a desired ending inventory of 20 percent of next quarter's sales. Create the production budget in numbers of tents for quarters one through four for the current year. Ask SANDY'S CAMPING GEAR Budgeted Production Q1 Q2 Q3 Q4 Add: Desired ending inventory Production budget in number of tents Mc Graw Hillarrow_forwardPlease help me with show all calculation thankuarrow_forward
- The marketing department of Jessi Corporation submitted the following sales forecast for next year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12,900 13,900 15,900 14,900 Budgeted unit sales The selling price of the company's product is $28 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made and 20% in the following quarter; 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in the first quarter, is $74,000. The company expects to start the first quarter with 2,580 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 2,780 units. Required: 1. alculate the estimated sales for each quarter and for the year as a whole. 2. Calculate the expected cash collections…arrow_forwardInfinity Inc. has provided the following projected sales units for the next quarter: Projected Sales Units First month Second month Third month Projected sales units 10,000 12,000 15,000 Desired ending inventory is determined to be 10% of the next month’s projected sales. The expected purchase cost per unit is $50. Compute the budgeted Costs of goods sold for the next quarter. Group of answer choices $1,850,000 $600,000 $500,000 $750,000arrow_forwardHH Company is in the process of preparing the cash budget for the last four months of 2022 that is September to December. The following information has been made available. Sept Oct Nov Dec Projected sales quantity (units) 60,000 65,000 65,000 70,000 Additional information: Selling price is ksh 120 per unit but expected to drop by 5% from 1st Payment for goods sold is as follows; 20% in the month of sales, 70% the following month after sales and The balance in the second month after sales. Bad debt is estimated at 3% of sales value. Purchases of goods at ksh 65 per unit are as follows: September 88,000 units, October 84,000 units, November 95,000 units and December 80,000 units. Goods purchased are paid one month in arrears. Monthly expenses estimated at 15% on sales revenue are paid in the month of incurrence. The company plans to buy a delivery van at ksh 2,700,000, 40% of the cost to be paid in October and the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education