use the total sales revenue from the budget tab to calculate the product cost method

for questions 1&2 goes based on the budget chart

D E G H We want to make sure we are charging the right amount for our cupcakes. Use the "Budgets" tab to for the following calculations, 2 3 1. Cost-Plus Method - Because this is a highly consummable product and people are more apt to repurchase on a weekly basis, management has decided the markup should be 45%. Use the total Direct Materials and Direct Labor from the Budgets tab. Use the Predetermined overhead rate from the EOS tab. Calculate the cost-plus method. Show Per unit cost 6 Direct Labor Markup per unit 7 Overhead Selling Price your work 5 Direct Materials 8 Total 9 10 2. Product Cost Method - With the Product Cost Method, the calculation should include estimated selling and administrative expenses. Use the total Direct Materials and Direct Labor from the Budgets tab. Use the Predetermined overhead rate from the EOS tab and the Selling/Administrative Expenses from below. The desired profit is listed below and is based on the contribution margin. Calculate the cost-plus method, Show your work. 11 12 Selling/Administrative S 315,250.00 Desired Profit 30.00% Direct Materials Per unit cost 13 14 Direct Labor Markup per unit 15 Overhead Selling Price 16 Total 17 18 Sales 19 Var Costs 20 CM 21 Desired Profit 22 23 you holes manager to optimize your product exposure. You now supply cupcakes to boutique hotels, bridal shops, and luxury shops Based on popularity, you only produce chocolate cupcakes with chocolate icing. Your sales manager is pushing for the company to create and maintain budgets. Create a Sales, Production, Materials, and Labor budget in preparation for the new year 15.00 Sales Budget The Sales Manager believes we can sell 36,000 dozen cupcakes during the first quarter Dan-Mar) and that there will be a quarterly increase see Sales Increase). In order to increase sales quarterly, we will need to reduce our customer price (see Customer Price). Create a Sales Budget for each quarter Sales Increase 3.50X Customer Price Quarters 01 Q2 Q3 Q: Total 9 Budgeted Sales 36,000 37,260 38.564 39,914 151,738 10 Selling price per dozen $ 15.00$ 15.00 $ 5.00 $ 15.00 11 Total Sales revenue $ 540,000.00 $ 558.900.00 $ 57,460.00 S 598,710.00 $ 2.276,070,00 12 13 14 Production Budget e Based on the Sales Budget create a Production Budget. We always want to have at least 1 day of Inventory. Beginning inventory is listed below 15 16 Beginning Inventory 356 17 Quarters 18 Qi 02 03 04 Total 19 Budgeted Sales 36,000 37,260 38.564 39,914 20 Desired Ending Inventory 21 Total Units Needed 36,000 37,260 38,564 39.914 22 Less: Beginning inventory 365 35,635 1,625 36,939 23 Required Production 35,635 1,625 36,939 2.975 24 25 Scenario 5 Points We want to make sure we are charging the right amount for our cupcakes. Use the "Budgets" tab to for the following calculations. 1. Cost-Plus Method - Because this is a highly consummable product and people are more apt to repurchase on a weekly basis, management has decided the markup should be 45%. Use the total Direct Materials and Direct Labor from the Budgets tab. Use the Predetermined overhead rate from the EOS tab. Calculate the cost-plus method. Show your work Direct Materials Per unit cost Direct Labor Markup per unit Overhead Selling Price Total 2. Product Cost Method - With the Product Cost Method, the calculation should include estimated selling and administrative expenses. Use the total Direct Materials and Direct Labor from the Budgets tab. Use the Predetermined overhead rate from the EOS tab and the Selling/Administrative Expenses from below. The desired profit is listed below and is based on the contribution margin. Calculate the cost-plus method. Show your work. 30.00% Selling/Administrative $ 315,250.00 Direct Materials Direct Labor Overhead Total Desired Profit Per unit cost Markup per unit Selling Price Sales Var Costs CM Desired Profit Jx We are beginning our second year. Iseduur D E H F A B AWN 1 Scenario 30 points We are beginning our second year. Instead of waiting for people to find your bakery, you hired a sales manager to optimize your product exposure. You now supply cupcakes to boutique hotels, bridal shops, and luxury shops. Based on popularity, you only produce chocolate cupcakes with chocolate icing. Your sales manager is pushing for the company to create and maintain budgets. Create a Sales, Production, Materials, and Labor 2 budget in preparation for the new year. 3 4 Sales Budget The Sales Manager believes we can sell 36,000 dozen cupcakes during the first quarter (Jan-Mar) and that there will be a quarterly increase (see Sales Increase). In order to increase sales quarterly, we will need to reduce our customer price (see Customer Price). Create a Sales Budget for each 5 quarter 6 Sales Increase 3.50% Customer Price $ 15.00 Quarters 8 Q1 Q2 Q4 Total 9 Budgeted Sales 36,000 37,260 38,564 39,914 151,738 10 Selling price per dozen $ 15.00 $ 15.00 $ 5.00 $ 15.00 11 Total Sales revenue $ 540,000.00 $ 558,900.00 $ 578,460.00 $ 598,710.00 $ 2,276,070.00 12 13 14 Production Budget 03 Based on the Sales Budget create a Production Budget. We always want to have at least 1 day of inventory. Beginning inventory is listed below 15 16 Beginning Inventory 356 17 Quarters 18 Q1 Q2 Q3 Q4 Total 19 Budgeted Sales 36,000 37,260 38,564 39,914 20 Desired Ending Inventory 21 Total Units Needed 36,000 37,260 38,564 39,914 22 Less: Beginning Inventory 365 35,635 1,625 36,939 23 Required Production 35,635 1,625 36,939 2,975 24 25 26 Moteriols Budget SENNETEG 1 Scenario 15 Points We want to make sure we are charging the right amount for our cupcakes. Use the "Budgets" tab to for the following calculations 3 1. Cost-Plus Method - Because this is a highly consummable product and people are more apt to repurchase on a weekly basis, management has decided the markup should be 45%. Use the total Direct Materials and Direct Labor 4 from the Budgets tab. Use the Predetermined overhead rate from the EOS tab. Calculate the cost-plus method. Show 5 your work 6 Direct Labor Markup per unit 7 Overhead Selling Price 8 Total 9 10 2. Product Cost Method - With the Product Cost Method, the calculation should include estimated selling and administrative expenses. Use the total Direct Materials and Direct Labor from the Budgets tab. Use the Predetermined overhead rate from the EOS tab and the Selling/Administrative Expenses from below. The desired profit is listed below and is based on the contribution margin. Calculate the cost-plus method. Show your work. 11 12 Selling/Administrative $ 315,250.00 Desired Profit 30.00% Direct Materials Per unit cost 13 14 Direct Labor Markup per unit 15 Overhead Selling Price 16 Total 17 18 Sales 19 Var Costs 20 CM 21 Desired Profit 22 Budots Variances Pricing Discussion + D 1 Scenario 30 points We are beginning our second year. Instead of waiting for people to find your bakery, you hired a sales manager to optimize your product exposure You now supply cupcakes to boutique hotels, bridal shops, and luxury shops. Based on popularity, you only produce chocolate cupcakes with chocolate icing. Your sales manager is pushing for the company to create and maintain budgets Create a Sales, Production, Materials, and Labor 2 budget in preparation for the new year Sales Budget The Sales Manager believes we can sell 36,000 dozen cupcakes during the first quarter (an-Mar) and that there will be a quarterly increase (see Sales Increase). In order to increase sales quarterly, we will need to reduce our customer price (see Customer Price). Create a Sales Budget for each 5 quarter. Sales increase 3.SON Customer Price $ 15:00 Quarters Q1 Q2 04 Total 9 Budgeted Sales 36,000 37,260 38,564 39,914 151,738 10 Selling price per dozen $ 15.00 $ 15.00 $ 5.00 $ 15.00 11 Total Sales revenue $ 540,000.00 $ 558,900.00 $ 578.460.00 $ 598,710.00 $ 2,276,070.00 12 13 4 Production Budget Based on the Sales Budget, create a Production Budget. We always want to have at least 1 day of inventory, Beginning inventory is listed below 6 Beginning Inventory 356 Quarters Q2 37,260 Q1 36,000 Total Q3 38,564 04 39,914 Budgeted Sales Desired Ending Inventory Total Units Needed Less: Beginning Inventory Required Production 36,000 365 35,635 37,260 35,635 1,625 38,564 1,625 36,939 39,914 36,939 2,975 D E G H We want to make sure we are charging the right amount for our cupcakes. Use the "Budgets" tab to for the following calculations, 2 3 1. Cost-Plus Method - Because this is a highly consummable product and people are more apt to repurchase on a weekly basis, management has decided the markup should be 45%. Use the total Direct Materials and Direct Labor from the Budgets tab. Use the Predetermined overhead rate from the EOS tab. Calculate the cost-plus method. Show Per unit cost 6 Direct Labor Markup per unit 7 Overhead Selling Price your work 5 Direct Materials 8 Total 9 10 2. Product Cost Method - With the Product Cost Method, the calculation should include estimated selling and administrative expenses. Use the total Direct Materials and Direct Labor from the Budgets tab. Use the Predetermined overhead rate from the EOS tab and the Selling/Administrative Expenses from below. The desired profit is listed below and is based on the contribution margin. Calculate the cost-plus method, Show your work. 11 12 Selling/Administrative S 315,250.00 Desired Profit 30.00% Direct Materials Per unit cost 13 14 Direct Labor Markup per unit 15 Overhead Selling Price 16 Total 17 18 Sales 19 Var Costs 20 CM 21 Desired Profit 22 23 you holes manager to optimize your product exposure. You now supply cupcakes to boutique hotels, bridal shops, and luxury shops Based on popularity, you only produce chocolate cupcakes with chocolate icing. Your sales manager is pushing for the company to create and maintain budgets. Create a Sales, Production, Materials, and Labor budget in preparation for the new year 15.00 Sales Budget The Sales Manager believes we can sell 36,000 dozen cupcakes during the first quarter Dan-Mar) and that there will be a quarterly increase see Sales Increase). In order to increase sales quarterly, we will need to reduce our customer price (see Customer Price). Create a Sales Budget for each quarter Sales Increase 3.50X Customer Price Quarters 01 Q2 Q3 Q: Total 9 Budgeted Sales 36,000 37,260 38.564 39,914 151,738 10 Selling price per dozen $ 15.00$ 15.00 $ 5.00 $ 15.00 11 Total Sales revenue $ 540,000.00 $ 558.900.00 $ 57,460.00 S 598,710.00 $ 2.276,070,00 12 13 14 Production Budget e Based on the Sales Budget create a Production Budget. We always want to have at least 1 day of Inventory. Beginning inventory is listed below 15 16 Beginning Inventory 356 17 Quarters 18 Qi 02 03 04 Total 19 Budgeted Sales 36,000 37,260 38.564 39,914 20 Desired Ending Inventory 21 Total Units Needed 36,000 37,260 38,564 39.914 22 Less: Beginning inventory 365 35,635 1,625 36,939 23 Required Production 35,635 1,625 36,939 2.975 24 25 Scenario 5 Points We want to make sure we are charging the right amount for our cupcakes. Use the "Budgets" tab to for the following calculations. 1. Cost-Plus Method - Because this is a highly consummable product and people are more apt to repurchase on a weekly basis, management has decided the markup should be 45%. Use the total Direct Materials and Direct Labor from the Budgets tab. Use the Predetermined overhead rate from the EOS tab. Calculate the cost-plus method. Show your work Direct Materials Per unit cost Direct Labor Markup per unit Overhead Selling Price Total 2. Product Cost Method - With the Product Cost Method, the calculation should include estimated selling and administrative expenses. Use the total Direct Materials and Direct Labor from the Budgets tab. Use the Predetermined overhead rate from the EOS tab and the Selling/Administrative Expenses from below. The desired profit is listed below and is based on the contribution margin. Calculate the cost-plus method. Show your work. 30.00% Selling/Administrative $ 315,250.00 Direct Materials Direct Labor Overhead Total Desired Profit Per unit cost Markup per unit Selling Price Sales Var Costs CM Desired Profit Jx We are beginning our second year. Iseduur D E H F A B AWN 1 Scenario 30 points We are beginning our second year. Instead of waiting for people to find your bakery, you hired a sales manager to optimize your product exposure. You now supply cupcakes to boutique hotels, bridal shops, and luxury shops. Based on popularity, you only produce chocolate cupcakes with chocolate icing. Your sales manager is pushing for the company to create and maintain budgets. Create a Sales, Production, Materials, and Labor 2 budget in preparation for the new year. 3 4 Sales Budget The Sales Manager believes we can sell 36,000 dozen cupcakes during the first quarter (Jan-Mar) and that there will be a quarterly increase (see Sales Increase). In order to increase sales quarterly, we will need to reduce our customer price (see Customer Price). Create a Sales Budget for each 5 quarter 6 Sales Increase 3.50% Customer Price $ 15.00 Quarters 8 Q1 Q2 Q4 Total 9 Budgeted Sales 36,000 37,260 38,564 39,914 151,738 10 Selling price per dozen $ 15.00 $ 15.00 $ 5.00 $ 15.00 11 Total Sales revenue $ 540,000.00 $ 558,900.00 $ 578,460.00 $ 598,710.00 $ 2,276,070.00 12 13 14 Production Budget 03 Based on the Sales Budget create a Production Budget. We always want to have at least 1 day of inventory. Beginning inventory is listed below 15 16 Beginning Inventory 356 17 Quarters 18 Q1 Q2 Q3 Q4 Total 19 Budgeted Sales 36,000 37,260 38,564 39,914 20 Desired Ending Inventory 21 Total Units Needed 36,000 37,260 38,564 39,914 22 Less: Beginning Inventory 365 35,635 1,625 36,939 23 Required Production 35,635 1,625 36,939 2,975 24 25 26 Moteriols Budget SENNETEG 1 Scenario 15 Points We want to make sure we are charging the right amount for our cupcakes. Use the "Budgets" tab to for the following calculations 3 1. Cost-Plus Method - Because this is a highly consummable product and people are more apt to repurchase on a weekly basis, management has decided the markup should be 45%. Use the total Direct Materials and Direct Labor 4 from the Budgets tab. Use the Predetermined overhead rate from the EOS tab. Calculate the cost-plus method. Show 5 your work 6 Direct Labor Markup per unit 7 Overhead Selling Price 8 Total 9 10 2. Product Cost Method - With the Product Cost Method, the calculation should include estimated selling and administrative expenses. Use the total Direct Materials and Direct Labor from the Budgets tab. Use the Predetermined overhead rate from the EOS tab and the Selling/Administrative Expenses from below. The desired profit is listed below and is based on the contribution margin. Calculate the cost-plus method. Show your work. 11 12 Selling/Administrative $ 315,250.00 Desired Profit 30.00% Direct Materials Per unit cost 13 14 Direct Labor Markup per unit 15 Overhead Selling Price 16 Total 17 18 Sales 19 Var Costs 20 CM 21 Desired Profit 22 Budots Variances Pricing Discussion + D 1 Scenario 30 points We are beginning our second year. Instead of waiting for people to find your bakery, you hired a sales manager to optimize your product exposure You now supply cupcakes to boutique hotels, bridal shops, and luxury shops. Based on popularity, you only produce chocolate cupcakes with chocolate icing. Your sales manager is pushing for the company to create and maintain budgets Create a Sales, Production, Materials, and Labor 2 budget in preparation for the new year Sales Budget The Sales Manager believes we can sell 36,000 dozen cupcakes during the first quarter (an-Mar) and that there will be a quarterly increase (see Sales Increase). In order to increase sales quarterly, we will need to reduce our customer price (see Customer Price). Create a Sales Budget for each 5 quarter. Sales increase 3.SON Customer Price $ 15:00 Quarters Q1 Q2 04 Total 9 Budgeted Sales 36,000 37,260 38,564 39,914 151,738 10 Selling price per dozen $ 15.00 $ 15.00 $ 5.00 $ 15.00 11 Total Sales revenue $ 540,000.00 $ 558,900.00 $ 578.460.00 $ 598,710.00 $ 2,276,070.00 12 13 4 Production Budget Based on the Sales Budget, create a Production Budget. We always want to have at least 1 day of inventory, Beginning inventory is listed below 6 Beginning Inventory 356 Quarters Q2 37,260 Q1 36,000 Total Q3 38,564 04 39,914 Budgeted Sales Desired Ending Inventory Total Units Needed Less: Beginning Inventory Required Production 36,000 365 35,635 37,260 35,635 1,625 38,564 1,625 36,939 39,914 36,939 2,975