Managerial Accounting

Please fill in the blanks

All of the data I have is included

Calibri 11 ' ' General LG > Wrap Text Merge & Center LE BIU A $ % 9 8-98 Conditional For Formatting Tab oard S Font Alignment Number Style Xfx Direct Materials urchases Budget A B D E F G H Current Designs Kayak Company Direct Materials Purchases Budget Composite Rotomold Units to be produced Part 1 Polyethelene needed for production Pounds per unit Total pounds needed for production Polyethelene needed for ending inventory 0 0 Less beginning inventory Pounds of polyethelene to be purchased Price per pound Cost of Polyethelene powder $ $ $ $ Part 2 Kits needed for production Cashflow Bud Prod Budget You Prod Budget Material Purch Bud Yr Material Purch Budo General Calibri 11 A A BIU A 2 Wrap Text SEE Merge & Center Paste $ %, 8-98 Clipboard Font Alignment Number -4 Direct Materials Purchases Budget B D mm F 9 0 1 2 Part 2 Kits needed for production Kits per unit Total needed for production Kits needed for ending inventory 3 4 5 6 7 0 0 Less beginning inventory Kits to be purchased Price per Cost of Polyethelene powder 3 lun $ $ 9 $ $ 3 1 TOTALS $ $ 3 4 5. Accounting a.A- E B Merge & Center $ % 978-98 Conditional F Formatting 1 Font Alignment Number Xfx Composite B C D G H 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 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 S 13.75 $ 2.85 per pound 135.00 per kayak 17.90 per hour 13.89 per hour Applied overhead Driver Direct labor cost 25% Direct labor cost Overhead rate 25% DATA Cashflow Bud Prod Budget Yr Prod Biddet Material Purch Bud y Material Purch AutoSave ACC 122 FINAL PROJECT Kayak Production Budget 11-30-20 File Home Insert Page Layout Formulas Data Review View Help X IL Calibri = Accounting Paste 2 Wrap Text Es Merge & Center - BIU a-A- $ % 58-98 Conditional Format as Cell Formatting Table Styles Clipboard Font 15 Alignment Number F6 Composite A E 22 F Q1 03 04 QS 23 24 25 B D Expected unit sales Number of composite kayaks Number of rotomolded kayaks 225 720 G Q2 475 1,430 1905 70 835 905 160 780 940 230 650 945 880 26 27 28 Q2 Q3 Q4 Expected unit selling price Number of composite kayaks Number of rotomolded kayaks $ s Q1 900 $ 750 $ 810 $ 675 S 900 $ 29 Q5 900 750 900 $ 750 $ 750 $ 30 31 32 33 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 34 35 36 37 38 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 39 0 41 12. Percentage of completion at end of period Complete Partial For composite kayaks 950 50 50% Forrotomolded kavaks 3.500 500 50% DATA Cashflow Bud Prod Budget Prod Budget a Material Purch Bud Yr Material Purch - Calibri 11 ' ' General LG > Wrap Text Merge & Center LE BIU A $ % 9 8-98 Conditional For Formatting Tab oard S Font Alignment Number Style Xfx Direct Materials urchases Budget A B D E F G H Current Designs Kayak Company Direct Materials Purchases Budget Composite Rotomold Units to be produced Part 1 Polyethelene needed for production Pounds per unit Total pounds needed for production Polyethelene needed for ending inventory 0 0 Less beginning inventory Pounds of polyethelene to be purchased Price per pound Cost of Polyethelene powder $ $ $ $ Part 2 Kits needed for production Cashflow Bud Prod Budget You Prod Budget Material Purch Bud Yr Material Purch Budo General Calibri 11 A A BIU A 2 Wrap Text SEE Merge & Center Paste $ %, 8-98 Clipboard Font Alignment Number -4 Direct Materials Purchases Budget B D mm F 9 0 1 2 Part 2 Kits needed for production Kits per unit Total needed for production Kits needed for ending inventory 3 4 5 6 7 0 0 Less beginning inventory Kits to be purchased Price per Cost of Polyethelene powder 3 lun $ $ 9 $ $ 3 1 TOTALS $ $ 3 4 5. Accounting a.A- E B Merge & Center $ % 978-98 Conditional F Formatting 1 Font Alignment Number Xfx Composite B C D G H 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 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 S 13.75 $ 2.85 per pound 135.00 per kayak 17.90 per hour 13.89 per hour Applied overhead Driver Direct labor cost 25% Direct labor cost Overhead rate 25% DATA Cashflow Bud Prod Budget Yr Prod Biddet Material Purch Bud y Material Purch AutoSave ACC 122 FINAL PROJECT Kayak Production Budget 11-30-20 File Home Insert Page Layout Formulas Data Review View Help X IL Calibri = Accounting Paste 2 Wrap Text Es Merge & Center - BIU a-A- $ % 58-98 Conditional Format as Cell Formatting Table Styles Clipboard Font 15 Alignment Number F6 Composite A E 22 F Q1 03 04 QS 23 24 25 B D Expected unit sales Number of composite kayaks Number of rotomolded kayaks 225 720 G Q2 475 1,430 1905 70 835 905 160 780 940 230 650 945 880 26 27 28 Q2 Q3 Q4 Expected unit selling price Number of composite kayaks Number of rotomolded kayaks $ s Q1 900 $ 750 $ 810 $ 675 S 900 $ 29 Q5 900 750 900 $ 750 $ 750 $ 30 31 32 33 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 34 35 36 37 38 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 39 0 41 12. Percentage of completion at end of period Complete Partial For composite kayaks 950 50 50% Forrotomolded kavaks 3.500 500 50% DATA Cashflow Bud Prod Budget Prod Budget a Material Purch Bud Yr Material Purch