Managerial Accounting

Production budget for each quarter for both Composite and Rotomold brand kayaks

Please fill in the blanks

All of the data that I have is included

Folding lable Font Alignment Number Styles f B G H C D E Current Designs Kayak Company Production Budget - Units to be produced Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 5 Composite Expected unit sales Required ending inventory Total required units Beginning inventory Required production units 50 50 50 Rotomold Expected unit sales Required ending inventory Total required units Beginning inventory Required production units 150 150 150 200 Total Instructions DATA Cashflow Bud Prod Budget You Prod BudgetQ Material Purch Bud Yr Type here to search O Font Alignment Number x for G D Current Designs Kayak Company Production Cost and Projected Sales Data Standared costing for raw materials and labor Standard Quantities Polyethylene powder Finishing kit Type I labor Type Il labor Composite 44.50 2.00 3.00 3.10 Rotomold 64.75 pounds 2.00 each 3.50 hours 2.80 hours Standard Costs Polyethylene powder Finishing kits Type I labor rate Type Il labor rate $ $ $ $ 2.90 $ 125.00 $ 15.00 $ 13.75 $ 2.85 per pound 135.00 per kayak 17.90 13.89 per hour per hour Applied overhead Driver Direct labor cost 25% Direct labor cost Overhead rate 25% Instructions DATA Cashflow Bud Prod Budget Yr Prod Budget Material Purch Bud Yr Home Insert Page Layout Formulas Data Review View Help Calibri 11 - A A a. A 2 Wrap Text Merge & Center Accounting $ - % 8-98 Font Alignment Conditional Format as Co Formatting Table Styles Styles Number Composite E B D Expected unit sales Number of composite kayaks Number of rotomolded kayaks Q1 H Q3 1 Q4 225 720 945 G Q2 475 1,430 1,905 70 835 905 160 780 940 Q5 230 650 880 Q1 Q2 Q3 Q4 Expected unit selling price Number of composite kayaks Number of rotomolded kayaks Q5 S $ 900 $ 750 $ 810 $ 675$ 900 S 750 $ 900 $ 750 $ 900 750 Inventory Requirements Polyethelene Finished goods Finish kits 15% of amount required for production in the next quarter 23% of projected sales for next quarter 10% of amount required for production in the next quarter Cash collections and payments TERMS All sales are made on account. 50% collected in the quarter sold, the balance is collected in the following quarter Expenses are paid: 80% in the quarter they are incurred, 20% in the following quartert Partial Percentage of completion at end of period For composite kayaks For rotomolded kavaks astructions DATA Cashflow Bud Prod Budget Yr Complete 950 3.500 Prod Budget 50 50% 500 50% Material Purch Bud Yr