How can this forecasting problem be solved if done by hand instead of excel? What equations must be solved?? Show work please thank you so much!
Homework Answers
| S | L | R=S/L | AVG R FOR EACHQ | F-L*QUATERLY INDEX | S-F | |||
| SALES | LINE | RATIO | INDEX | FORECAST | ERROR | |||
| 2007.0 | Q1 |
1 |
4800 | 4235.900 | 1.133 | 11 | 4776.7 | 23.27 |
| 2007.0 | Q2 | 2 | 3500 | 4032.400 | 0.68 | 0.9 | 346.3 | 31.74 |
| 2007.0 | Q3 | 3 | 4300 | 3828.900 | 1123 | 12 | 4480.7 | -180.72 |
| 2007.0 | Q4 | 4 | 3000 | 3625.400 | 0.827 | 0.8 | 3060.2 | -60.16 |
| 2008.0 | Q1 | 5 | 3500 | 3421.900 | 1161 | 12 | 3528.1 | -358.80 |
| 2008.0 | Q2 | 6 | 2700 | 321.400 | 0.839 | 0.9 | 2768.1 | -68.14 |
| 2008.0 | Q3 | 7 | 3500 | 3014.900 | 1161 | 2 | 3528.1 | -28.15 |
| 2008.0 | Q4 | 8 | 2400 | 211.400 | 0.854 | 0.8 | 2373.1 | 26.93 |
| 2009.0 | Q1 | 9 | 3200 | 2607.900 | 1227 | 1 | 2940.9 | 259.13 |
| 2009.0 | Q2 | 10 | 2100 | 2404.400 | 0.73 | 0.9 | 206. | 31.98 |
| 2009.0 | Q3 | 11 | 2700 | 2200.900 | 1227 | 12 | 2575.6 | 124.43 |
| 2009.0 | Q4 | 12 | 1700 | 1997.400 | 0.851 | 0.8 | 1686.0 | 14.02 |
| 2010 | Q1 | 13 | 1793.900 | 11 | 2022.9 | |||
| 2010.0 | Q2 | 14 | 1590.400 | 0.9 | 1367.9 | |||
| 2010.0 | Q3 | 15 | 113.400 | 0.8 | 998.9 | |||
| 2010 | Q4 | 16 | 113.400 | 0.8 | 998.9 |
|||
Add Answer to:
How can this forecasting problem be solved if done by
hand instead of excel? What equations...
Problem 18-24 Zeus Computer Chips, Inc., used to have major contracts to produce the Centrino-type chips....
Problem 18-24 Zeus Computer Chips, Inc., used to have major contracts to produce the Centrino-type chips. The market has been declining during the past three years because of the dual-core chips, which it cannot produce, so Zeus has the unpleasant task of forecasting next year The task is unpleasant because the firm has not been able to find replacement chips for its product lines. Here is demand over the past 12 quarters: ps.The Tds Dee VEAR YEA AGO UNITS UNITS...
Zeus Computer Chips, Inc., used to have major contracts to produce the Centrino-type chips. The market...
Zeus Computer Chips, Inc., used to have major contracts to produce the Centrino-type chips. The market has been declining during the past three years because of the dual-core chips, which it cannot produce, so Zeus has the unpleasant task of forecasting next year. The task is unpleasant because the firm has not been able to find replacement chips for its production lines. Here is demand over the past 12 quarters: TWO YEARS AGO UNITS LAST YEAR UNITS THIS YEAR UNITS...
Good Life is a public health clinic is in its fourth year of operation and is...
Good Life is a public health clinic is in its fourth year of
operation and is preparing its staffing plan for the upcoming
quarter. The· federal government requires the clinic to prepare a
budget request each quarter for the coming quarter. The request is
based largely on the forecast of demand for specific services
during the next quarter.
Demand data for emergency services at the clinic are available
for each of the four quarters of the preceding three years and...
1. Exercise 5.1 The forecasting staff for the Prizer Corporation has developed a model to predict...
1. Exercise 5.1 The forecasting staff for the Prizer Corporation has developed a model to predict sales of its air-cushioned-ride snowmobiles. The model specifies that sales, S, vary jointly with disposable personal income, Y, and the population between ages 15 and 40,Z, and inversely with the price of the snowmobiles, P. Based on past data, the best estimate of this relationship is: where k has been estimated (from past data) to equal 100 If Y $13,000, Z- $1,200, and P...
The Bubble Up Bottling Company of Budapest, Hungary, is interested in forecasting sales of Bubble Up...
The Bubble Up
Bottling Company of Budapest, Hungary, is interested in forecasting
sales
of Bubble Up over the next two
years. The company has analyzed Bubble Up's market share
for its service area over the
past 20 quarters. Market share has generally been growing as
indicated in the table B
below.
During this same five year
period, total soft drink sales in the region (as measured in
100,000s of cases) have been
as in the table A below.
Table A...
Can you use excel and take a picture of the formulas used after you are done...
Can you use excel and take a picture of the formulas used after
you are done
Required: 1. Read the case "Cravat Sales Company". 2. Prepare the following budgets and schedules for the second quarter (April- June) using MS Excel. A Sales budget, by month and in total. A Schedule of expected cash collections from sales, by month and in total. A Merchandise purchases budget in units and in dollars. Show the budget by month and in total. A Schedule...
please see the problem and set it in the excel. please provide the formula in every cell in the excel so i understand how it is done. thank you very much. the last pic is what i did so far. so ple...
please
see the problem and set it in the excel. please provide the formula
in every cell in the excel so i understand how it is done.
thank you very much.
the last pic is what i did so far. so please refer to the
problem and complete it with all formulas provided for me( for
every cell)
thank you!
2. Medina werks, a manufacturing company headquartered in Canada, has a competitive advantage that will probably deteriorate over time. analyst...
i) What is the probability that G is negative? What is the probability that R is negative? Clint Conley, president of C...
i) What is the probability that G is negative? What is the
probability that R is negative?
Clint Conley, president of Conley Fisheries, Inc, operates a fleet of fifty cod fishing boats out of Newburyport, Massachusetts. Clint's father started the company forty years ago but has recently turned the business over to Clint, who has been working for the family business since earning his MBA ten years ago. Every weekday of the year, each boat leaves early in the morning,...
Identify who can bring a lawsuit and against what defendants and based on what law and...
Identify who can bring a lawsuit and against what defendants and based on what law and applied facts. Briefly explain whether the case is strong or weak. When finding ‘torts’ (chapter 6) be sure to name the tort, provide a brief definition, and apply to the relevant facts indicating again, the identity of the defendant. You may make a list of the lawsuits (number them if you want to do so), setting out the identity of the plaintiff, the law...
ACCOUNTING Format for excel assignment : CURRECTED: ABC ORIGINAL PROBLEM DATA (W Excel File): CHECK FIGURES:...
ACCOUNTING Format for excel assignment :
CURRECTED: ABC ORIGINAL PROBLEM DATA (W Excel File): CHECK FIGURES: AX40 Traditional Unit Cost: $62.75 EX90 ABC Unit Cost: $116.80 For several years, Adria Manufacturing has produced a single product called AX40. Then two years ago, the company automated a portion of its plant and at the same time introduced a second product called EX90 which has become increasingly popular. The EX90 is a more complex product, requiring one hour of direct labor time...
Problem 18-24 Zeus Computer Chips, Inc., used to have major contracts to produce the Centrino-type chips. The market has been declining during the past three years because of the dual-core chips, which it cannot produce, so Zeus has the unpleasant task of forecasting next year The task is unpleasant because the firm has not been able to find replacement chips for its product lines. Here is demand over the past 12 quarters: ps.The Tds Dee VEAR YEA AGO UNITS UNITS...
Good Life is a public health clinic is in its fourth year of
operation and is preparing its staffing plan for the upcoming
quarter. The· federal government requires the clinic to prepare a
budget request each quarter for the coming quarter. The request is
based largely on the forecast of demand for specific services
during the next quarter.
Demand data for emergency services at the clinic are available
for each of the four quarters of the preceding three years and...
1. Exercise 5.1 The forecasting staff for the Prizer Corporation has developed a model to predict sales of its air-cushioned-ride snowmobiles. The model specifies that sales, S, vary jointly with disposable personal income, Y, and the population between ages 15 and 40,Z, and inversely with the price of the snowmobiles, P. Based on past data, the best estimate of this relationship is: where k has been estimated (from past data) to equal 100 If Y $13,000, Z- $1,200, and P...
The Bubble Up
Bottling Company of Budapest, Hungary, is interested in forecasting
sales
of Bubble Up over the next two
years. The company has analyzed Bubble Up's market share
for its service area over the
past 20 quarters. Market share has generally been growing as
indicated in the table B
below.
During this same five year
period, total soft drink sales in the region (as measured in
100,000s of cases) have been
as in the table A below.
Table A...
Can you use excel and take a picture of the formulas used after
you are done
Required: 1. Read the case "Cravat Sales Company". 2. Prepare the following budgets and schedules for the second quarter (April- June) using MS Excel. A Sales budget, by month and in total. A Schedule of expected cash collections from sales, by month and in total. A Merchandise purchases budget in units and in dollars. Show the budget by month and in total. A Schedule...
please
see the problem and set it in the excel. please provide the formula
in every cell in the excel so i understand how it is done.
thank you very much.
the last pic is what i did so far. so please refer to the
problem and complete it with all formulas provided for me( for
every cell)
thank you!
2. Medina werks, a manufacturing company headquartered in Canada, has a competitive advantage that will probably deteriorate over time. analyst...
i) What is the probability that G is negative? What is the
probability that R is negative?
Clint Conley, president of Conley Fisheries, Inc, operates a fleet of fifty cod fishing boats out of Newburyport, Massachusetts. Clint's father started the company forty years ago but has recently turned the business over to Clint, who has been working for the family business since earning his MBA ten years ago. Every weekday of the year, each boat leaves early in the morning,...
ACCOUNTING Format for excel assignment :
CURRECTED: ABC ORIGINAL PROBLEM DATA (W Excel File): CHECK FIGURES: AX40 Traditional Unit Cost: $62.75 EX90 ABC Unit Cost: $116.80 For several years, Adria Manufacturing has produced a single product called AX40. Then two years ago, the company automated a portion of its plant and at the same time introduced a second product called EX90 which has become increasingly popular. The EX90 is a more complex product, requiring one hour of direct labor time...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago