Cash flow budget

please fill in the blanks

ECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View 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 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 per hour 13.89 per hour Applied overhead Driver Direct labor cost 25% Direct labor cost 25% Overhead rate X for 15% of amount required for production in the next quarter B C D E G H 01 Q3 04 Q5 Expected unit sales Number of composite kayaks Number of rotomolded kayaks 225 720 Q2 475 1,430 1,905 70 835 905 160 780 940 230 650 945 880 Q1 Q2 Q3 Q5 Expected unit selling price Number of composite kayaks Number of rotomolded kayaks $ $ 900 $ 750 $ 810 $ 675 $ 900 $ 750 $ 04 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 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 Y Prod Budget Material Purch Bud Yr Type here to search O LUUL LUI X G H D E F CURRENT DESIGNS Projected Cashflow Budget For the Year Ending December 31, 2017 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total $ $ $ $ $ $ $ $ $ $ $ $ CASH RECEIPTS Composite Units to be sold Selling price Sales revenue Rotomold Units to be sold Selling price Sales revenue Total sales is $ $ $ $ $ $ $ $ $ $ $ $ $ S Cash collections $ $ $ $ $ $ CASH DISPERSEMENTS Cost of materials Cost of Labor $ $ $ $ $ $ Overhead cost Instructions DATA Cashflow Bud Prod Budget Yr Prod Budget Material Purch Bud Yr U U VUIL, I Laler to stay in Protected View Enable Editir E F G H Cash collections $ - $ $ $ $ $ $ $ $ $ CASH DISPERSEMENTS Cost of materials Cost of Labor Overhead cost Total $ $ $ $ $ Cash payments $ $ $ $ $ Net cashflow per quarter $ $ $ $ Instructions DATA Cashflow Bud Prod Budget Yr Prod Budget Material Purch Bud Yr ECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View 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 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 per hour 13.89 per hour Applied overhead Driver Direct labor cost 25% Direct labor cost 25% Overhead rate X for 15% of amount required for production in the next quarter B C D E G H 01 Q3 04 Q5 Expected unit sales Number of composite kayaks Number of rotomolded kayaks 225 720 Q2 475 1,430 1,905 70 835 905 160 780 940 230 650 945 880 Q1 Q2 Q3 Q5 Expected unit selling price Number of composite kayaks Number of rotomolded kayaks $ $ 900 $ 750 $ 810 $ 675 $ 900 $ 750 $ 04 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 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 Y Prod Budget Material Purch Bud Yr Type here to search O LUUL LUI X G H D E F CURRENT DESIGNS Projected Cashflow Budget For the Year Ending December 31, 2017 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total $ $ $ $ $ $ $ $ $ $ $ $ CASH RECEIPTS Composite Units to be sold Selling price Sales revenue Rotomold Units to be sold Selling price Sales revenue Total sales is $ $ $ $ $ $ $ $ $ $ $ $ $ S Cash collections $ $ $ $ $ $ CASH DISPERSEMENTS Cost of materials Cost of Labor $ $ $ $ $ $ Overhead cost Instructions DATA Cashflow Bud Prod Budget Yr Prod Budget Material Purch Bud Yr U U VUIL, I Laler to stay in Protected View Enable Editir E F G H Cash collections $ - $ $ $ $ $ $ $ $ $ CASH DISPERSEMENTS Cost of materials Cost of Labor Overhead cost Total $ $ $ $ $ Cash payments $ $ $ $ $ Net cashflow per quarter $ $ $ $ Instructions DATA Cashflow Bud Prod Budget Yr Prod Budget Material Purch Bud Yr