please type the answers

Question 2 18 points Dancer Company has noticed that utility bills are substantially higher when the average monthly temperature is colder. The only thing in the shop that uses natural gas is the furnace. Because of prevailing low temperatures, the furnace is used every month of the year (though less in the summer months and very little in August). Everything else in the shop runs on electricity, and electricity use is fairly constant throughout the year. For a your Duncer has been renting the wenge daily temperature and the cost of its monthly utility bills for natural gw and electricity, Average Temperature Month U Cool Idegrees Farnhell January 31 February March 45 30 Art 410 275 June % 3 % $ 220 210 305 Question Completion Status: February March 543 April May 46 275 June 50 233 July 53 220 August 00 210 September 50 305 October 10 530 November 30 750 December 10 STO Required 1. Use the high low method to find the equation for estimating the cost of utilitice 2. Estimate the utility cost for the upcoming month of January if the estimated average temperature is 26 degrees 3. Using Excel find the regression equation for estimating the cost of utilities. You may calculate the simple linear regression from the charting function, the cel formulas or the more function in the analysis toolpak Broger Bites has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if Broger discontinues frozen foods. The operating results from the most recent period are: Froten Treats Baked Goods Fresh Fruits Total Sales $120.000 $1.000 $164.175 v 17h Cord of good old 105,000 67.000 110,000 22.000 SFS estimates that store support expenses, In total, are approximately 20% of revenue The controller says that not every sales dollar requires or uses the same amount of store support activities. A preliminary analysis reveals store support activities for these three product inesse Activity (cost driver From Baked Goode 00 Fresh Fruit Toal.com driver with 120 200 Overed poate $12.00 Order processing number of the 20 15 75 100 $20.500 Recling rumber of deliveries) Shaking hours 30 170 300 250 delivers 500 sono Pro 150.000 un sol 30.000 40,000 36.000 Dato con Toledo $18.00 $56.600 Required 1. Volume based: What is the overhead rate per unit it Broger uses units sold as the cost driver? 2. Volume based: How much overhead is located to Frozen Treats using units sold as the allocation base? Volume based: What is the net profit or loss on the Frozen Treats? 4. Activity based: Calculate the overhead rate for each of the four activities above. (Order processing, receiving, shelf stocking, and customer support Activity based: How much overhead is located to Frozen Treats using the activity rates you calculated in part 4 Adda What the petitions on the Frozen From prontability it roger discontinues Frozen Toons. The operang results from the most recent period are Frozen Treats Baked Goods Fresh Fruits Total Sam $120,000 $91.000 $158, 175 $319, 175 Cost of goods sold 105.000 67.000 110,000 2012.000 SFS estimates that store support expenses, in total, are approximately 20% of revenue The controller says that not every sales dollar requires are the same amount of more support activities. A preliminary analysis reveals more support activities for these three product Activity cost deliver Fresh Fruits Tools Theat Overhead Goode ter unite Order processing rumber of purchase 20 $12.400 orden receiving thamber of deliver 15 70 100 20 20.00 30 170 300 500 . ing Otome contatto 30.000 000 16.00 315.000 Total whole 0.00 Required 1. Volume based: What is the overhead rate per unit Broger uses units sold as the cost driver? 2. Volume based: How much overhead is located to Frozen Treats using units sold as the allocation base? 3 Volume based: What is the net profit or loss on the Frozen Treats? Activity based: Calculate the overhead rate for each of the four activities above. (Order processing, receiving, helt stocking, and customer support) 5. Activity based: How much overhead is allocated to Frozen Treats using the activity rates you calculated in part 4 6. Activity based: What is the net profit or loss on the Frozen Treats? Question 2 18 points Dancer Company has noticed that utility bills are substantially higher when the average monthly temperature is colder. The only thing in the shop that uses natural gas is the furnace. Because of prevailing low temperatures, the furnace is used every month of the year (though less in the summer months and very bitle in August). Everything else in the shop runs on electricity, and electricity use is fairly constant throughout the year. For a year Duncer has been moonting the wenge daily temperature and the cost of the monthly utility bills for natural ga and electricity Average Temperature Month degrees Farenhet January 31 51760 February Aort 44 410 May 215 June 220 210 305 Question Completion Status: February March 543 Apri 410 May 40 275 June 50 230 53 220 July August 50 210 September 50 305 October 10 November 30 750 December 10 870 Required 1. Use the high low method to find the equation for estimating the cost of utilitice 2. Estimate the wality cost for the upcoming month of January if the estimated vergetemperature is 26 demes 3. Using Facel find the regression equation for estimating the cost of utilities. You may calculate the simple linear regrewide from the churting function, the feel formular or the fonction in the analysis toolpak Frozen Treats Broger Bltes has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if Broger discontinues frozen foods. The operating results from the most recent period are: Baked Goods Fresh Fruits Total Sales $120.000 $1.000 $154,175 10,175 Con of good old 105,000 67.000 110.000 22.000 SFS estimates that starte support expenses, in total, are approximately 20% of revenues The controller says that not every sales dollar requires or use the same amount of store support activities. A preliminary analysis reveals store support activities for these three product lines are Activity (cost every Frozen Trust 20 Baked Goode 60 Fresh Fruits Tico! driver unit 120 300 Overfend coste $12.00 Order processing number of purchase orders Receiving rumber of deliveries) Shaking hours 15 75 100 20.500 30 170 300 250 Over 500 sono Troue 150.000 un sold Data scorso 30.000 40,000 85.000 315.000 Talado Required 1. Volume based: What is the overhead rate per unit it Broger Uses units sold as the cost driver? 2. Volume based: How much overhead is located to Frozen Treats using units sold as the allocation base? 3 Volume based: What is the net profit or loss on the Frozen Treats? Activity based: Calculate the overhead rate for each of the four activities above. (Order processing, receiving, shelf stocking, and customer support Activity based: How much overhead is allocated to Frozen Treats using the activity rates you calculated in part 4 Add What the nations on the Frozen prontanti roger discontinues trozen Tous ne operaong results from the most recent period are Froen Treats Baked Goode Fresh Fruits Total Sale $120,000 $91.000 $164,175 $310. 175 Cost of goods sold 105.000 07.000 110,000 212.000 SFS estimates that store support expenses, in total, are approximately 20% of revenue The controller says that not every sales dollar requires are the same amount of more support activities. A preliminary analysis reveals more support activities for these three product Activity to deve From Fresh Fruits Total Overhead ter und Order processing rumber of purchase 20 10 orden 12.400 receiving thamber of de 15 71 100 20 Shocking hours 30 170 300 100 1.000 Otome wote 30,000 0.000 1.000 16.000 315.000 Total whole 0.00 Required 1. Volume based: What is the overhead rate per unit if Broger uses units sold as the cost driver? 2. Volume based: How much overhead is located to Frozen Treats using units sold as the allocation base? 3. Volume based: What is the net profit or loss on the Frozen Treats? Activity Based: Calculate the overhead rate for each of the four activities above. (Order processing, receiving, helt stocking, and customer support) 5. Activity based: How much overhead is allocated to Frozen Treats using the activity rates you calculated in part 6. Activity based: What is the net profit or loss on the Frozen Treats? Question 2 18 points Dancer Company has noticed that utility bills are substantially higher when the average monthly temperature is colder. The only thing in the shop that uses natural gas is the furnace. Because of prevailing low temperatures, the furnace is used every month of the year (though less in the summer months and very little in August). Everything else in the shop runs on electricity, and electricity use is fairly constant throughout the year. For a yeur, Dancer has been recording the wenige daily temperature and the cost of its monthly utility bills for natural gas and electricity Average Temperature Month (degrees Farenhet tillty Cost 31 51760 January February 1,620 March 543 Apri 44 410 May 46 275 June 50 233 53 220 30 210 August September 50 305 Question Completion Status: January $1,700 February March 43 543 April 44 410 May 46 June 50 233 53 220 July August 60 210 September 50 October 40 530 November 30 750 December 10 870 Required 1. Use the high low method to find the equation for estimate the cost of utilities 2. Estimate the utility.com for the upcoming month of the crime average temperature i 26 de 3. Using Excel find the regresion equation for estimating the cost of utilices. You may calculate the simple linear regression from the charting function, the Excel formula, the regression function in the analysis toolpak Question 2 18 points Dancer Company has noticed that utility bills are substantially higher when the average monthly temperature is colder. The only thing in the shop that uses natural gas is the furnace. Because of prevailing low temperatures, the furnace is used every month of the year (though less in the summer months and very little in August). Everything else in the shop runs on electricity, and electricity use is fairly constant throughout the year. For a your Duncer has been renting the wenge daily temperature and the cost of its monthly utility bills for natural gw and electricity, Average Temperature Month U Cool Idegrees Farnhell January 31 February March 45 30 Art 410 275 June % 3 % $ 220 210 305 Question Completion Status: February March 543 April May 46 275 June 50 233 July 53 220 August 00 210 September 50 305 October 10 530 November 30 750 December 10 STO Required 1. Use the high low method to find the equation for estimating the cost of utilitice 2. Estimate the utility cost for the upcoming month of January if the estimated average temperature is 26 degrees 3. Using Excel find the regression equation for estimating the cost of utilities. You may calculate the simple linear regression from the charting function, the cel formulas or the more function in the analysis toolpak Broger Bites has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if Broger discontinues frozen foods. The operating results from the most recent period are: Froten Treats Baked Goods Fresh Fruits Total Sales $120.000 $1.000 $164.175 v 17h Cord of good old 105,000 67.000 110,000 22.000 SFS estimates that store support expenses, In total, are approximately 20% of revenue The controller says that not every sales dollar requires or uses the same amount of store support activities. A preliminary analysis reveals store support activities for these three product inesse Activity (cost driver From Baked Goode 00 Fresh Fruit Toal.com driver with 120 200 Overed poate $12.00 Order processing number of the 20 15 75 100 $20.500 Recling rumber of deliveries) Shaking hours 30 170 300 250 delivers 500 sono Pro 150.000 un sol 30.000 40,000 36.000 Dato con Toledo $18.00 $56.600 Required 1. Volume based: What is the overhead rate per unit it Broger uses units sold as the cost driver? 2. Volume based: How much overhead is located to Frozen Treats using units sold as the allocation base? Volume based: What is the net profit or loss on the Frozen Treats? 4. Activity based: Calculate the overhead rate for each of the four activities above. (Order processing, receiving, shelf stocking, and customer support Activity based: How much overhead is located to Frozen Treats using the activity rates you calculated in part 4 Adda What the petitions on the Frozen From prontability it roger discontinues Frozen Toons. The operang results from the most recent period are Frozen Treats Baked Goods Fresh Fruits Total Sam $120,000 $91.000 $158, 175 $319, 175 Cost of goods sold 105.000 67.000 110,000 2012.000 SFS estimates that store support expenses, in total, are approximately 20% of revenue The controller says that not every sales dollar requires are the same amount of more support activities. A preliminary analysis reveals more support activities for these three product Activity cost deliver Fresh Fruits Tools Theat Overhead Goode ter unite Order processing rumber of purchase 20 $12.400 orden receiving thamber of deliver 15 70 100 20 20.00 30 170 300 500 . ing Otome contatto 30.000 000 16.00 315.000 Total whole 0.00 Required 1. Volume based: What is the overhead rate per unit Broger uses units sold as the cost driver? 2. Volume based: How much overhead is located to Frozen Treats using units sold as the allocation base? 3 Volume based: What is the net profit or loss on the Frozen Treats? Activity based: Calculate the overhead rate for each of the four activities above. (Order processing, receiving, helt stocking, and customer support) 5. Activity based: How much overhead is allocated to Frozen Treats using the activity rates you calculated in part 4 6. Activity based: What is the net profit or loss on the Frozen Treats? Question 2 18 points Dancer Company has noticed that utility bills are substantially higher when the average monthly temperature is colder. The only thing in the shop that uses natural gas is the furnace. Because of prevailing low temperatures, the furnace is used every month of the year (though less in the summer months and very bitle in August). Everything else in the shop runs on electricity, and electricity use is fairly constant throughout the year. For a year Duncer has been moonting the wenge daily temperature and the cost of the monthly utility bills for natural ga and electricity Average Temperature Month degrees Farenhet January 31 51760 February Aort 44 410 May 215 June 220 210 305 Question Completion Status: February March 543 Apri 410 May 40 275 June 50 230 53 220 July August 50 210 September 50 305 October 10 November 30 750 December 10 870 Required 1. Use the high low method to find the equation for estimating the cost of utilitice 2. Estimate the wality cost for the upcoming month of January if the estimated vergetemperature is 26 demes 3. Using Facel find the regression equation for estimating the cost of utilities. You may calculate the simple linear regrewide from the churting function, the feel formular or the fonction in the analysis toolpak Frozen Treats Broger Bltes has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if Broger discontinues frozen foods. The operating results from the most recent period are: Baked Goods Fresh Fruits Total Sales $120.000 $1.000 $154,175 10,175 Con of good old 105,000 67.000 110.000 22.000 SFS estimates that starte support expenses, in total, are approximately 20% of revenues The controller says that not every sales dollar requires or use the same amount of store support activities. A preliminary analysis reveals store support activities for these three product lines are Activity (cost every Frozen Trust 20 Baked Goode 60 Fresh Fruits Tico! driver unit 120 300 Overfend coste $12.00 Order processing number of purchase orders Receiving rumber of deliveries) Shaking hours 15 75 100 20.500 30 170 300 250 Over 500 sono Troue 150.000 un sold Data scorso 30.000 40,000 85.000 315.000 Talado Required 1. Volume based: What is the overhead rate per unit it Broger Uses units sold as the cost driver? 2. Volume based: How much overhead is located to Frozen Treats using units sold as the allocation base? 3 Volume based: What is the net profit or loss on the Frozen Treats? Activity based: Calculate the overhead rate for each of the four activities above. (Order processing, receiving, shelf stocking, and customer support Activity based: How much overhead is allocated to Frozen Treats using the activity rates you calculated in part 4 Add What the nations on the Frozen prontanti roger discontinues trozen Tous ne operaong results from the most recent period are Froen Treats Baked Goode Fresh Fruits Total Sale $120,000 $91.000 $164,175 $310. 175 Cost of goods sold 105.000 07.000 110,000 212.000 SFS estimates that store support expenses, in total, are approximately 20% of revenue The controller says that not every sales dollar requires are the same amount of more support activities. A preliminary analysis reveals more support activities for these three product Activity to deve From Fresh Fruits Total Overhead ter und Order processing rumber of purchase 20 10 orden 12.400 receiving thamber of de 15 71 100 20 Shocking hours 30 170 300 100 1.000 Otome wote 30,000 0.000 1.000 16.000 315.000 Total whole 0.00 Required 1. Volume based: What is the overhead rate per unit if Broger uses units sold as the cost driver? 2. Volume based: How much overhead is located to Frozen Treats using units sold as the allocation base? 3. Volume based: What is the net profit or loss on the Frozen Treats? Activity Based: Calculate the overhead rate for each of the four activities above. (Order processing, receiving, helt stocking, and customer support) 5. Activity based: How much overhead is allocated to Frozen Treats using the activity rates you calculated in part 6. Activity based: What is the net profit or loss on the Frozen Treats? Question 2 18 points Dancer Company has noticed that utility bills are substantially higher when the average monthly temperature is colder. The only thing in the shop that uses natural gas is the furnace. Because of prevailing low temperatures, the furnace is used every month of the year (though less in the summer months and very little in August). Everything else in the shop runs on electricity, and electricity use is fairly constant throughout the year. For a yeur, Dancer has been recording the wenige daily temperature and the cost of its monthly utility bills for natural gas and electricity Average Temperature Month (degrees Farenhet tillty Cost 31 51760 January February 1,620 March 543 Apri 44 410 May 46 275 June 50 233 53 220 30 210 August September 50 305 Question Completion Status: January $1,700 February March 43 543 April 44 410 May 46 June 50 233 53 220 July August 60 210 September 50 October 40 530 November 30 750 December 10 870 Required 1. Use the high low method to find the equation for estimate the cost of utilities 2. Estimate the utility.com for the upcoming month of the crime average temperature i 26 de 3. Using Excel find the regresion equation for estimating the cost of utilices. You may calculate the simple linear regression from the charting function, the Excel formula, the regression function in the analysis toolpak