Question

EB3. LO 7.2 Barnstormer sells airplane accessories for $20 each. It expects sales of 120,000 units in quarter 1 and a 7% incr

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1) Sales budget

1st quarter 2nd quarter 3rd quarter 4th quarter Year
Sales unit 120000 128400 137388 147005 532793
Selling price 20 20 20 20 20
Sales revenue 2400000 2568000 2747760 2940100 10655860

2) Production budget

1st month 2nd month 3rd month 4th month
Sales 3000 2000 2500 2700
Add: desired ending inventory 400 500 540 580
Total 3400 2500 3040 3280
Less: Beginning inventory -600 -400 -500 -540
Production units 2800 2100 2540 2740
Add a comment
Know the answer?
Add Answer to:
EB3. LO 7.2 Barnstormer sells airplane accessories for $20 each. It expects sales of 120,000 units...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Part 1 Patrick Inc. sells industrial solvents in 5-gallon drums. Patrick expects the following units to...

    Part 1 Patrick Inc. sells industrial solvents in 5-gallon drums. Patrick expects the following units to be sold in the first 3 months of the coming year: January 41,000 February 38,000 March 50,000 The average price for a drum is $43. Required: Prepare a sales budget for the first 3 months of the coming year, showing units and sales revenue by month and in total for the quarter. Do not include a multiplication symbol as part of your answer. Patrick...

  • Company expects to sell 9,000 units for $ 160 each for a total of $ 1,440,000...

    Company expects to sell 9,000 units for $ 160 each for a total of $ 1,440,000 in January and 2,800 units for $ 195 each for a total of $ 546,000 in February. The company expects cost of goods sold to average 60​% of sales​ revenue, and the company expects to sell 5 c,000 units in March for $ 230 each. Arete​'s target ending inventory is $ 20 comma 000 plus 60​% of the next​ month's cost of goods sold....

  • E10.18 Prepare quarterly sales budgets. Roche and Young, CPAS, are preparing their service revenue (sales) budget...

    E10.18 Prepare quarterly sales budgets. Roche and Young, CPAS, are preparing their service revenue (sales) budget for 2020. Their practice is divided into three departments: auditing, tax, and consulting. Billable hours for each department, by quarter, are as follows: Department Quarter 1 Quarter 2 Quarter 3 Quarter 4 Auditing 2,200 1,600 2,000 2,400 3,000 2,500 Тах 2,400 2,000 Consulting 1,500 1,500 1,500 1,500 Average hourly billing rates are $60 for auditing, $70 for tax, and $80 for consulting services. Instructions...

  • Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects...

    Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects the following unit sales: January 41,000 February 38,000 March 50,000 April 51,000 Patrick's policy is to have 20% of next month's sales in ending inventory. On January 1, it is expected that there will be 4,700 drums of solvent on hand. Required: Prepare a production budget for the first quarter of the year. Show the number of drums that should be produced each month...

  • E10.19 Prepare quarterly production budgets. (LO 2) Wayans Company produces and sells automobile batteries, inclu...

    E10.19 Prepare quarterly production budgets. (LO 2) Wayans Company produces and sells automobile batteries, including the heavy-duty HD-240. The 2020 sales budget is as follows: Quarter Units of HD-240 1 6,000 7,000 9,000 10,000 The January 1, 2020, inventory of HD-240 is 1,500 units. Management wants an ending inventory each quarter that is equal to 30% of the next quarter's sales. It expects sales in the first quarter of 2021 to be 20% higher than sales in the same quarter...

  • DUE SOON, PLEASE HELP!!! Sales for the final quarter of the prior year total 800 units. Expected sales in units) for the...

    DUE SOON, PLEASE HELP!!! Sales for the final quarter of the prior year total 800 units. Expected sales in units) for the current year are: 720 (Quarter 1), 480 (Quarter 2), 640 (Quarter 3), and 640 (Quarter 4). Sales for the first quarter of the following year total 960 units. The selling price is $660 per unit in the first three quarters of the year, and $690 per unit in the final quarter. Company policy calls for a given quarter's...

  • Company expects to sell 8,000 units for $165 each for a total of $1,320,000 in January...

    Company expects to sell 8,000 units for $165 each for a total of $1,320,000 in January and 1,500 units for $195 each for a total of $292,500 in February. The company expects cost of goods sold to average 50​% of sales​ revenue, and the company expects to sell 4,700 units in March for $260 each. Arete​'s target ending inventory is $17,000 plus 60​% of the next​month's cost of goods sold. Prepare Arete​'s inventory, purchases, and cost of goods sold budget...

  • Yosko Company expects to sell 2.050 units of finished product in January and 2.400 units in...

    Yosko Company expects to sell 2.050 units of finished product in January and 2.400 units in February The company has 150 units on hand on January 1 and desires to have an ending inventory equal to 60% of the next month's sales. March sales are expected to be 2.500 units Prepare Yoko's production budget for January and February Select the labels, enter the amounts and prepare the production budget for January. Then, prepare the production budget for February Yosko Company...

  • Schwartz and Company expects to sell 100 units in the first quarter and 90 units in...

    Schwartz and Company expects to sell 100 units in the first quarter and 90 units in the second quarter. Assuming the company prefers to maintain finished goods inventory equal to 10 percent of the next quarter’s sales, prepare a production budget for the first quarter using as a guide. (Hint: you are preparing a production budget for the first quarter only.)

  • Outdoor Company expects to sell 6500 units for $ 155 each for a total of $...

    Outdoor Company expects to sell 6500 units for $ 155 each for a total of $ 1,007,500 in January and 3 comma 200 units for $ 225 each for a total of $ 720,000 in February. The company expects cost of goods sold to average 50% of sales revenue, and the company expects to sell 4400 units in March for $ 270 each. Outdoor's target ending inventory is $ 11000 plus 40% of the next month's cost of goods sold....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT