To remember: 1. We produce 120 products per day: 80 for chocolate dip & 40 for caramel dip 2. Chocolate Dip Total cost of the product without the profit margin = P72 With profit margin = 295 3.Caramel Dip Total cost of the product without the profit margin = P64 With profit margin = P85 = = = ============ EEE ================== I. PRODUCTION BUDGET a) Create a 3-year forecasted production budget using the template provided. Year 1 Production Budget 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Total Period Planned Sales Desired Ending Inventory Total Needs Beggining Inventory Units to be produced 0 0 0 0 0 0 0 0 0 0 Year 2 Production Budget 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Total Period Planned Sales Desired Ending Inventory Total Needs Beggining Inventory Units to be produced 0 0 0 0 0 0 0 0 0 0 Year 3 Production Budget 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Total Period Planned Sales Desired Ending Inventory Total Needs Beggining Inventory Units to be Produced 0 0 0 0 0 0 0 0 0 0 b) Create your own assumptions for the succeeding forecast for each year and the whole year in total. EXAMPLE: PRODUCTION BUDGET ASSUMPTIONS BELOW: 1. IN THIS CASE, THE DESIRED INVENTORY WAS ARBITRARILY SET AT 150. 2. THE BEGINNING INVENTORY FOR A GIVEN QUARTER IS THE SAME AS PREVIOUS QUARTER'S ENDING INVENTORY. THE BEGINNING INVENTORY OF 1ST QUARTER IS 100. Your Assumptions: To remember: 1. We produce 120 products per day: 80 for chocolate dip & 40 for caramel dip 2. Chocolate Dip Total cost of the product without the profit margin = P72 With profit margin = 295 3.Caramel Dip Total cost of the product without the profit margin = P64 With profit margin = P85 = = = ============ EEE ================== I. PRODUCTION BUDGET a) Create a 3-year forecasted production budget using the template provided. Year 1 Production Budget 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Total Period Planned Sales Desired Ending Inventory Total Needs Beggining Inventory Units to be produced 0 0 0 0 0 0 0 0 0 0 Year 2 Production Budget 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Total Period Planned Sales Desired Ending Inventory Total Needs Beggining Inventory Units to be produced 0 0 0 0 0 0 0 0 0 0 Year 3 Production Budget 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Total Period Planned Sales Desired Ending Inventory Total Needs Beggining Inventory Units to be Produced 0 0 0 0 0 0 0 0 0 0 b) Create your own assumptions for the succeeding forecast for each year and the whole year in total. EXAMPLE: PRODUCTION BUDGET ASSUMPTIONS BELOW: 1. IN THIS CASE, THE DESIRED INVENTORY WAS ARBITRARILY SET AT 150. 2. THE BEGINNING INVENTORY FOR A GIVEN QUARTER IS THE SAME AS PREVIOUS QUARTER'S ENDING INVENTORY. THE BEGINNING INVENTORY OF 1ST QUARTER IS 100. Your Assumptions