Question

CALCULATOR PRINTER VERSION BACK NEXT > Exercise 5-12 Concord manufactures competition stunt kites. In November, Jerry Box prepared the following production budget for the first quarter of the coming year. Desired ending inventory is based on the following month's budgeted sales, Budgeted unit Sales Budgeted ending inventory Total units required Beginning inventory Budgeted production January February March Quarter 23,500 37,800 31,800 93,100 7,560 6,360 2,640 2,640 31,060 44,160 34,440 95,740 4,700 7.560 6,360 4,700 26.360 36,600 28,080 91,040 Following higher than expected sales in December, Jerry conducted an inventory count on January 2 and discovered that the company had only 2.590 completed kites on hand. He decided that given the brisk sales in December, the company should increase its desired ending inventory level from 20 to 25 percent of the next month's sales volume. (a) Prepare a new production budget for the first quarter. (Round answers to O decimal places, e.g. 5, 275.) January February March Quarter Budgeted unit sales 23,500 37,800 31,800 93,100 Budgeted ending inventory 9,450 7.950 Total units required Beginning inventory Budgeted production Click if you would like to Show Work for this question: Open Show Work LINK TO TEXT

Answer 1

Answer

1 3 Budgeted Sales (Units) 4 Desired ending inventory 5 Total units required 6 Less: Beginning inventory 7 Budgeted Production B C D E Production Budget January February March Total 23,500.00 37,800.00 31,800.00 93,100.00 9,450.00 7,950.00 3,300.00 3,300.00 32,950.00 45,750.00 35,100.00 | 96,400.00 2,590.00 9,450.00 7,950.00 2,590.00 30,360.00 36,300.00 27,150.00 93,810.00

Calculations:

1 B C D E Production Budget January February March Total 3 Budgeted Sales (Units) 23500 37800 31800 =SUM(B3:D3) 4. Desired ending inventory =C3*0.25 =D3*0.25 3300 3300 5 Total units required =SUM(B3:B4) I=SUM(C3:04) I=SUM(D3:04) I=SUM(E3:E4) 6 Less: Beginning inventory 2590 =B4 =C4 2590 7 Budgeted Production =C5-C6 =D5-D6 =E5-E6

In case of any doubt, please comment.