Managerial Accounting

Production Budget for Composite brand kayaks and Rotomold brand kayaks

Please fill in the blanks

All of the data that I have is included

BI U A 33 35 Merge Font Alignment Production Budget - Units to be produc B Current Designs Kayak Company Production Budget - Units to be produced Composite Expected unit sales Required ending inventory Total required units Beginning inventory Required production units Rotomold Expected unit sales Required ending inventory Total required units Beginning inventory Required production units Total Instructions DATA Cashflow Bud Prod Budget Y Prod Bu For Font Alignment Number X 15% of amount required for production in the next quarter B G H D E 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 II 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 II labor rate $ $ $ $ 2.90 $ 125.00 $ 15.00 $ 13.75 $ 2.85 per pound 135.00 per kayak 17.90 per hour 13.89 per hour Applied overhead Driver Direct labor Direct labor cost 25% cost Overhead rate 25% Instructions DATA Cashflow Bud Calibri General ' ' a A E 2 Wrap Test Mergo & Center BIU I $ - % 48 - M: Conditional Format as Call Formatting Table Styles Styles Font Alignment Nurnber M f 15% of amount required for production in the next quarter B C D E F G H Q1 Q2 Q3 Q4 Q5 Expected unit selling price Number of composite kayaks Number of rotomolded kayaks $ $ 900 $ 750 $ 810 $ 675$ 900 $ 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 palance is collected in the following quarter Expenses are paid: 80% in the quarter they are incurred, 20% in the following quartert Percentage of completion at end of period For composite kayaks For rotomolded kayaks Complete 950 3,500 Partial 50 500 50% 50% Instructions DATA Cashflow Bud Prod Budget Yi Prod Budget Material Purch Bud Yr Type here to search