a) Calculate the 3-month Moving Average Forecast for sales from April/2019 to Januar enter them in the table above. b) Calculate MAD, MSE and MAPE for the forecast obtained from April/2019 to January/20 oblem #3- At Freeze Inc. the manufacturing of each air conditioning has a variable cost of $500 per unit ace in a facility 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 b 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.
a) Calculate the 3-month Moving Average Forecast for sales from April/2019 to Januar enter them in the table above. b) Calculate MAD, MSE and MAPE for the forecast obtained from April/2019 to January/20 oblem #3- At Freeze Inc. the manufacturing of each air conditioning has a variable cost of $500 per unit ace in a facility 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 b 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.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section: Chapter Questions
Problem 42P: The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars)...
Related questions
Question
Problem #2 A & B please
Problem #3 A 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
Actual Sales
3-Month Moving
Average Forecast- Sales
(# of Product X)
(# of Product X)
Jan/19
Feb/19
1,860
2,040
Mar/19
Apr/19
May/19
Jun/19
Jul/19
Aug/19
Sep/19
Oct/19
Nov/19
Dec/19
Jan/20
3,560
4,200
6,250
7,980
10,200
9,800
9,900
9,950
7,890
5,350
5,020
а)
Calculate the 3-month Moving Average Forecast for sales from April/2019 to January/2020 and
enter them in the table above.
b) (1
- 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 facility that has a monthly fixed cost of $250,000.
DINT 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?
а.
b.
С.
d.
POINT) If Freeze Inc. sells 600 units at $1,000 each on a given month, calculate the profit.
е.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fdd3c27d4-b808-4d72-a714-fa9a685b9143%2Fe3ee4ea3-2424-47fe-afdc-ff3a3fb8cba6%2Ftrw4im_processed.jpeg&w=3840&q=75)
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
Actual Sales
3-Month Moving
Average Forecast- Sales
(# of Product X)
(# of Product X)
Jan/19
Feb/19
1,860
2,040
Mar/19
Apr/19
May/19
Jun/19
Jul/19
Aug/19
Sep/19
Oct/19
Nov/19
Dec/19
Jan/20
3,560
4,200
6,250
7,980
10,200
9,800
9,900
9,950
7,890
5,350
5,020
а)
Calculate the 3-month Moving Average Forecast for sales from April/2019 to January/2020 and
enter them in the table above.
b) (1
- 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 facility that has a monthly fixed cost of $250,000.
DINT 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?
а.
b.
С.
d.
POINT) If Freeze Inc. sells 600 units at $1,000 each on a given month, calculate the profit.
е.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing