can someone please help me with this?
Case 1 - Glaze Ice Cream Factory grew, For this case, review your lecture notes on Topics 2 and 3. Glaze is a regional ice cream chain in the Midwest that produces its own ice cream. Glaze creates high-quality, premium ice cream. They produce classic ice cream flavors (like vanilla and chocolate) as well as some exotic ice cream flavors like "Polynesian Fantasy" or "Mango Lemon Supreme". While Glaze began as a small operation, founded by Claire Bosley. As Glaze Claire decided to rent a building for production and has since been able to afford more expense, automated manufacturing equipment. Glaze's most significant production costs are for the raw materials (like cream or sugar) and for the operation and maintenance of the production equipment. All of Glaze's products are sold at the same retail price, which is approximately a markup of 100% on production costs. Currently, Claire uses the plantwide allocation method to estimate product costs of each ice cream. Her plantwide manufacturing overhead rate is 200% of direct labor costs (i.e. $2/DLS). Although Claire is an expert in ice cream, she has much less experience in accounting. Claire hired you to take a look at her current costing system to make sure she was pricing her product well. Claire prepared a few exhibits for you to use in your analysis (found in the excel spreadsheet). In Exhibit 1, Claire lists out the budgeted manufacturing overhead costs. In Exhibit 2, Claire provides detailed information on the production of the "Polynesian Fantasy" and "Vanilla" flavors. Throughout the assignment, use excel formulas that reference the exhibits instead of hard-coding values. Required: de bobiva vodited or magni oboro 0. You will be assigned a number. Download the excel file from Blackboard that matches your number. For example, Student I will download GlazeCase 1.xlsx 57 GlazeCase_18 - AutoSave Data Review View Formulas Developer H File Home Page Layout insert Draw Times New Roman 12 29 B A lilil 13 III III THI Paste Clipboard Font Alignment Num B5 X Budgeted Manufacturing Overhead Cost H per order 1846 per hour per hour per hour per batch B D 2 Name(s): 3 4 Exhibiti 5 Budgeted Manufacturing Overhead Cost 6 Activity Est. Cost Driver Est. Drivels's Per Driver Cost 7 Purchasing $80,000 Purchase Orders 909 8 Material Handeling $95,000 Set Ups per set up 9 Blending $122.000 Blender Hours 1000 10 Freezing $175,000 Freezer Hours 1936 11 Packaging $110,000 Packing Machine Hours 1100 12 Quality Control $18,000 Batches 286 13 14 Exhibit 2 15 Detailed Production Information 16 Break Out Polynesian Vanilla 17 Direct Material $2.00 per gallon $1.80 per gallon 18 Direct Labor $1.20 per gallon $1.20 per gallon 19 Budgeted Production 2.000 gallons 100,000 gallons 20 Batch Size 100 gallons 2.500 gallons 21 Set Ups 3 per batch 3 per batch 22 Purchase Order Size 50 gallons 1.000 gallons 23 Blender Time 0.6 hours per 100 gallons 0.3 hours per 100 gallons 24 Freezer Time 1.0 hours per 100 gallons 1.0 hours per 100 gallons 25 Packeine Machine Timd 0 3 hours per 100 gallons 02 hours ner 100 manns Sheet1 Lenovo View Search Draw Home For Developer Page Layout 12 Times New Roman Conditional Formatting M 1 9 A $ 96 A > Nu Al Tant Doud BS Budgeted Manufacturing Overhead Cost E H Vanilla 4 27 28 29 30 31 B D Required 1. Plantwide Allocation Method: Polynesian Direct Materials/gallon Direct Labor gallon MOH/gallon (DL2) - Total Cost/Gallon 33 34 35 36 Required 2. Activity Based Costing Method: 37 38 39 40 Compute Number of Drivers for Budgeted Production Polynesian Vanilla Purchase Orders Purchase Orders Set Ups Set Ups Blender Hours Blender Hours Freezer Hours Freezer Hours Packing Machine Hours Packing Machine Hours Batches Batches 41 42 Shett Lenovo X FS F6 F7 FB F9 F10 FI + $ & % 5 1 2 3 4 6 7 8 9 Q W E R T Y U O Glease 1 - Excel View D Form Developer Page Layout X Roma 5- 96 The format a Table 7 Cell Styles A Alignment F Budgeted Manufacturing Overhead Cost G D Vanilla 45 Polynesian 46 47 48 49 50 51 52 53 Direct Materials Direct Labor MOH - Purchasing MOH - Material Handling MOH. Blending MOH-Freezing MOH- Packaging MOH - Quality Control - Total Cost *Number of Gallons - Total Cost/Gallon 55 56 57 58 59 60 61 Required 3: Evaluate your Findings:
Sheet Lenovo ESC + Y FT 2 FS F4 F6 F7 FB F9 & Case 1 - Glaze Ice Cream Factory grew, For this case, review your lecture notes on Topics 2 and 3. Glaze is a regional ice cream chain in the Midwest that produces its own ice cream. Glaze creates high-quality, premium ice cream. They produce classic ice cream flavors (like vanilla and chocolate) as well as some exotic ice cream flavors like "Polynesian Fantasy" or "Mango Lemon Supreme". While Glaze began as a small operation, founded by Claire Bosley. As Glaze Claire decided to rent a building for production and has since been able to afford more expense, automated manufacturing equipment. Glaze's most significant production costs are for the raw materials (like cream or sugar) and for the operation and maintenance of the production equipment. All of Glaze's products are sold at the same retail price, which is approximately a markup of 100% on production costs. Currently, Claire uses the plantwide allocation method to estimate product costs of each ice cream. Her plantwide manufacturing overhead rate is 200% of direct labor costs (i.e. $2/DLS). Although Claire is an expert in ice cream, she has much less experience in accounting. Claire hired you to take a look at her current costing system to make sure she was pricing her product well. Claire prepared a few exhibits for you to use in your analysis (found in the excel spreadsheet). In Exhibit 1, Claire lists out the budgeted manufacturing overhead costs. In Exhibit 2, Claire provides detailed information on the production of the "Polynesian Fantasy" and "Vanilla" flavors. Throughout the assignment, use excel formulas that reference the exhibits instead of hard-coding values. Required: de bobiva vodited or magni oboro 0. You will be assigned a number. Download the excel file from Blackboard that matches your number. For example, Student I will download GlazeCase 1.xlsx 57 GlazeCase_18 - AutoSave Data Review View Formulas Developer H File Home Page Layout insert Draw Times New Roman 12 29 B A lilil 13 III III THI Paste Clipboard Font Alignment Num B5 X Budgeted Manufacturing Overhead Cost H per order 1846 per hour per hour per hour per batch B D 2 Name(s): 3 4 Exhibiti 5 Budgeted Manufacturing Overhead Cost 6 Activity Est. Cost Driver Est. Drivels's Per Driver Cost 7 Purchasing $80,000 Purchase Orders 909 8 Material Handeling $95,000 Set Ups per set up 9 Blending $122.000 Blender Hours 1000 10 Freezing $175,000 Freezer Hours 1936 11 Packaging $110,000 Packing Machine Hours 1100 12 Quality Control $18,000 Batches 286 13 14 Exhibit 2 15 Detailed Production Information 16 Break Out Polynesian Vanilla 17 Direct Material $2.00 per gallon $1.80 per gallon 18 Direct Labor $1.20 per gallon $1.20 per gallon 19 Budgeted Production 2.000 gallons 100,000 gallons 20 Batch Size 100 gallons 2.500 gallons 21 Set Ups 3 per batch 3 per batch 22 Purchase Order Size 50 gallons 1.000 gallons 23 Blender Time 0.6 hours per 100 gallons 0.3 hours per 100 gallons 24 Freezer Time 1.0 hours per 100 gallons 1.0 hours per 100 gallons 25 Packeine Machine Timd 0 3 hours per 100 gallons 02 hours ner 100 manns Sheet1 Lenovo View Search Draw Home For Developer Page Layout 12 Times New Roman Conditional Formatting M 1 9 A $ 96 A > Nu Al Tant Doud BS Budgeted Manufacturing Overhead Cost E H Vanilla 4 27 28 29 30 31 B D Required 1. Plantwide Allocation Method: Polynesian Direct Materials/gallon Direct Labor gallon MOH/gallon (DL2) - Total Cost/Gallon 33 34 35 36 Required 2. Activity Based Costing Method: 37 38 39 40 Compute Number of Drivers for Budgeted Production Polynesian Vanilla Purchase Orders Purchase Orders Set Ups Set Ups Blender Hours Blender Hours Freezer Hours Freezer Hours Packing Machine Hours Packing Machine Hours Batches Batches 41 42 Shett Lenovo X FS F6 F7 FB F9 F10 FI + $ & % 5 1 2 3 4 6 7 8 9 Q W E R T Y U O Glease 1 - Excel View D Form Developer Page Layout X Roma 5- 96 The format a Table 7 Cell Styles A Alignment F Budgeted Manufacturing Overhead Cost G D Vanilla 45 Polynesian 46 47 48 49 50 51 52 53 Direct Materials Direct Labor MOH - Purchasing MOH - Material Handling MOH. Blending MOH-Freezing MOH- Packaging MOH - Quality Control - Total Cost *Number of Gallons - Total Cost/Gallon 55 56 57 58 59 60 61 Required 3: Evaluate your Findings: Sheet Lenovo ESC + Y FT 2 FS F4 F6 F7 FB F9 &
