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: Actual Sales (# of Product X) 3-Month Moving Average Forecast -Sales (# of Product X) Month Jan/19 Feb/19 Mar/19 Apr/19 May/19 Jun/19 Jul/19 Aug/19 Sep/19 Oct/19 Nov/19 Dec/19 Jan/20 1,860 2,040 3,560 4,200 6,250 7,980 10,200 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.

Intermediate Algebra
19th Edition
ISBN:9780998625720
Author:Lynn Marecek
Publisher:Lynn Marecek
Chapter12: Sequences, Series And Binomial Theorem
Section12.3: Geometric Sequences And Series
Problem 12.58TI: What is the total effect on the economy of a government tax rebate of $500 to each household in...
icon
Related questions
Question

help please 

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.
е.
Transcribed Image 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. е.
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Algebra
Intermediate Algebra
Algebra
ISBN:
9780998625720
Author:
Lynn Marecek
Publisher:
OpenStax College