Problem #2 – The table below shows the total number of air conditioning units sold in whole country by Freeze Inc. from January to December of 2019: Month 3-Month Moving Average Forecast - Sales (# of...


help please


Problem #2 – The table below shows the total number of air conditioning units sold in whole country by Freeze Inc. from<br>January to December of 2019:<br>Month<br>3-Month Moving<br>Average Forecast - Sales<br>(# of Product X)<br>Actual Sales<br>(# of Product X)<br>Jan/19<br>Feb/19<br>Mar/19<br>Apr/19<br>May/19<br>Jun/19<br>Jul/19<br>1,860<br>2,040<br>3,560<br>4,200<br>6,250<br>7,980<br>10,200<br>Aug/19<br>Sep/19<br>Oct/19<br>Nov/19<br>Dec/19<br>Jan/20<br>9,800<br>9,900<br>9,950<br>7,890<br>5,350<br>5,020<br>a)<br>enter them in the table above.<br>- Calculate the 3-month Moving Average Forecast for sales from April/2019 to January/2020 and<br>b)<br>- Calculate MAD, MSE and MAPE for the forecast obtained from April/2019 to January/2020.<br>Problem #3 – At Freeze Inc. the manufacturing of each air conditioning has a variable cost of $500 per unit and it takes<br>place in a facilitv that has a monthly fixed cost of $250,000.<br>If Freeze Inc. sells each unit at $1,000, how many units do they need to sell every month to break-even?<br>What is the monthly revenue at the break-even point?<br>What is the monthly variable cost at the break-even point?<br>What is the total operating cost at the break-even point?<br>If Freeze Inc. sells 600 units at $1,000 each on a given month, calculate the profit.<br>а.<br>b.<br>с.<br>d.<br>е.<br>

Extracted text: Problem #2 – The table below shows the total number of air conditioning units sold in whole country by Freeze Inc. from January to December of 2019: Month 3-Month Moving Average Forecast - Sales (# of Product X) Actual Sales (# of Product X) Jan/19 Feb/19 Mar/19 Apr/19 May/19 Jun/19 Jul/19 1,860 2,040 3,560 4,200 6,250 7,980 10,200 Aug/19 Sep/19 Oct/19 Nov/19 Dec/19 Jan/20 9,800 9,900 9,950 7,890 5,350 5,020 a) enter them in the table above. - Calculate the 3-month Moving Average Forecast for sales from April/2019 to January/2020 and b) - Calculate MAD, MSE and MAPE for the forecast obtained from April/2019 to January/2020. Problem #3 – At Freeze Inc. the manufacturing of each air conditioning has a variable cost of $500 per unit and it takes place in a facilitv that has a monthly fixed cost of $250,000. If Freeze Inc. sells each unit at $1,000, how many units do they need to sell every month to break-even? What is the monthly revenue at the break-even point? What is the monthly variable cost at the break-even point? What is the total operating cost at the break-even point? If Freeze Inc. sells 600 units at $1,000 each on a given month, calculate the profit. а. b. с. d. е.

Jun 08, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here