Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call onhe first day of each month, compute your forecast sales by each of the three methods requested here.ACTUALJune152JulyAugust192222. Using a simple three-month moving average, what is the forecast for September? (Round your answer to 2 decimal places.)Forecast for Septembero. Using a weighted moving average, what is the forecast for September with weights of 0.20, 0.30, and 0.50 for June, July, andAugust, respectively? (Do not round intermediate calculations. Round your answer to 2 decimal places.)Forecast for September. Using single exponential smoothing and assuming that the forecast for June had been 140, forecast sales for September with amoothing constant alpha of 0.30. (Round your answer to 2 decimal places.)Forecast for September

Name: Assume that your stock of sales merchandise is maintained based on th
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call onhe first day of each month, compute your forecast sales by each of the three methods requested here.ACTUALJune152July

(a). Find the forecast for September using a simple three-month moving average: The forecast for…

Math

Statistics

Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on he first day of each month, compute your forecast sales by each of the three methods requested here.

Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on he first day of each month, compute your forecast sales by each of the three methods requested here.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Q: Consider the Honduran market for soybeans. The following graph shows the domestic demand and…

A: Total Surplus s2 TS =CS+PS = [0.5*125*(380-305)] + [0.5*125*(305-230)] = 4687.5+4687.5 = 9375

Q: Complete the following worksheet and then use it to calculate the coefficient of determination. 1.…

A: Linear Regression: In the model, the dependent variable Y is the response variable and…

Q: Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet…

A: Part 2: Approach to solving the question:To construct an appropriate spreadsheet model for…

Q: Molly O'Malley is the new manager of the materials storeroom for Tudor Manufacturing. Mollly has…

A: Given data: MonthCost of PurchaseQuantity Purchased, XJanuary124102,650…

Q: Ross White’s machine shop uses 2500 brackets during the course of a year, and this usage is…

A: To determine the reorder point for Ross White's machine shop, we need to calculate the safety stock…

Q: Explain the theory behind the supply function

A: Solution The relationship between the quantities supplied and the determinants of supply is called…

Q: A car rental company is developing a replacement plan for its car fleet over the next 4 years. Based…

Q: Consider the listed actual demand in the table to the left. If the 6-week moving average forecast…

A: The question is about forecasting Given :

Q: Suppose that a company needs 1,800,000 items during a year and that preparation for each production…

Q: Draw the profit - loss diagram of the following positions on Apple Stock: Own stock at S0 (Spot…

A: In conclusion, the profit-loss diagram for the described position on Apple stock, which involves…

Q: They also find that the sample standard deviation is 4.1 bottles per week. One of them knows that…

A: Given that Sample size n=30 Sample mean x¯=9.9 Sample standard deviation s=4.1 Confidence level…

Q: Alexia your friend is a busy mandating company who is selling 1950 television sets a week at $540…

A: Sol:- a) To find the linear demand function D(q), we need to use the given information that the…

Q: George Caloz & Frères, located in Grenchen, Switzerland, makes luxury custom watches in small lots.…

A: We have to draw the regression line for the given data:Assuming X is the number of units processed…

Q: ASK YOUR TEACHE Nationwide Communications offers its customers a monthly plan for text messaging.…

Q: Month October November December January February March April May June July August September October…

A: The provided values are inserted in Excel as follows:

Q: The following equations are the demand and supply of a firm. P = 50 -q ( demand equation) P = 10+q(…

Q: The reorder point is defined as the lead-time demand for an item. In cases of long lead times, the…

A: Introduction: To calculate the reorder point in terms of the inventory position and in terms of the…

Q: Explain in your own words the relationship between price elasticity of demand and total revenue.…

A: Answer: Price elasticity of demand measures the responsiveness of demand after a change in…

Q: The Company’s research department has provided the following estimates: A demand of 230 banquet…

A: Here we are given with two catering services. We have to give recommendation for Which catering…

Q: Mode 1 2 3 2 3 Model 1 2 2 R Square .886 .938 .970 a. Predictors: (Constant), X3 - Advertising…

A: Solution: From the given information, the dependent variable is Unit sales. Independent variables…

Q: your natural gas bill is calculated as sum of the fixed monthly cost and a rate per therm of natural…

A: Here given your natural gas bill is calculated as sum of the fixed monthly cost and a rate per therm…

Q: Eid-ul-Adha is right around the corner. Every year End largely affects the commodity market.…

A: a) A price ceiling is always set below the equilibrium level of price for it to be effective. This…

Q: Espresso Express operates a number of espresso coffee stands in busy suburban malls. The fixed…

Q: A department store manager has determined that when the price of a skirt was $12 she sold 100 skirts…

Q: price

A: At Equilibrium, Demand = Supply,

Q: Describe the results of your two graphs as they compare to the movement of demand. Be specific.…

A: The given graph shows the forecasts and the original demand data.

Q: Find the equilibrium quantity and equilibrium price for the commodity whose supply and demand…

A: Given: Supply: P = 2Q+20 Demand: P = 200-2Q2

Q: Your Turn: The Gas Guzzler Tax is imposed on manufacturers on the sale of new-model cars (not…

A: We have, MPG (M)12.513.514.515.516.517.518.519.520.521.522.5Tax per car (T)…

Topic Video

Question

Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on
he first day of each month, compute your forecast sales by each of the three methods requested here.
ACTUAL
June
152
July
August
192
222
. Using a simple three-month moving average, what is the forecast for September? (Round your answer to 2 decimal places.)
Forecast for September
o. Using a weighted moving average, what is the forecast for September with weights of 0.20, 0.30, and 0.50 for June, July, and
August, respectively? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
Forecast for September
. Using single exponential smoothing and assuming that the forecast for June had been 140, forecast sales for September with a
moothing constant alpha of 0.30. (Round your answer to 2 decimal places.)
Forecast for September

Expert Solution

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!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Optimization$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions

The monthly demand for Williams Tchotchkes (q measured in 1000s of tchotchkes) depends on the price that they set for their tchotchkes (p measured in dollars), the average price of substitutes for their tchotchkes (p, also measured in dollars), and the average monthly disposable income in the market for tchotchkes (y measured in $1000s). The current prices are p = $10 and p₁ = $11, the current monthly demand for Williams Tchotchkes is 8000 tchotchkes and the current average monthly disposable income in the tchotchkes market is $3500. Furthermore, it is known that Əq Op p=10 Pg=11 y=3.5 = -0.31, Əq aps P=10 Pg=11 y=3.5 = 0.44 and Əq dy p=10 Pg=11 y=3.5 = 0.72. Scenario 1: Suppose that p increases by $0.20, p, increases by $0.35 (from their current values), and income doesn't change. In this scenario, monthly demand for Williams Tchotchkes' monthly will [Select] , and Williams Tchotchkes' monthly revenue will [Select] Scenario 2: Now (instead) suppose that average monthly income in the…
If Starbright Coffee Shop could get 1 more pound of coffee, which one should it be?What would be the effect on sales of getting 1 more pound of this coffee?• If the costs associated with increasing brewing capacity from 30 gallons to 40 gallonsper day come out to roughly $15 per day, would such a change be profitable?• If the shop spent $20 per day on advertising that would increase the relative demandfor Pomona to twice that of Coastal, should it be done?
The company has data on demand and factory capacity for the next 4 months as in the table. Unit cost with regular time $ 24, overtime cost $ 28, on subcontract $ 34. Storage costs $ 2 per unit per month; backorders cost $ 5 per unit per month. Initial inventory is as many as 120 units, and it is expected that by the end of July there will be an inventory of 100 units. April May June July Demand 460 450 480 480 Regular Capacity 370 370 380 380 Overtime Capacity 60 60 60 60 Subcontract Capacity 30 30 30 30 Use the transportation method to optimize the aggregate plan. Determine the production cost each month and the total cost for 4 months
Use the midpoint method to calculate the price elasticity of demand as the price of cakes increases from $8 to $10 if (a) your income is $20,000 and (b) your income is $24,000.
Suppose you are the marketing manager of a firm, and you plan to introduce a new product to the market. You have to estimate the first year net profit, which depends on several variables • Sales volume (in units) • Price per unit • Unit cost . Fixed costs Your net profit is net profit = sales volume x (price per unit-unit cost) - fixed cost The fixed cost is $120, 000, but other factors have some uncertainty. Based on your market research, there are equal chance that the market will be slow, ok, or hot. • Slow market the sales volume follows Poisson distribution with mean 50,000 units product, and the average price per unit is $11.00 ● Ok market the sales volume follows Poisson distribution with mean 75,000 units product, the average price per unit is $10.00 Hot market: the sales volume follows Poisson distribution with mean 100,000 units product, but the competition is severe so you expect the average price per unit is just $8.00 No matter what the market type is, your average unit…
From the data given compute the sales price for each product T and O. From the data given compute variable cost per unit for each product T and O. Letter Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 50,000 units of each product. Sales and costs for each product follow.
Two competing companies produce mobile phones. Company A starts production at 1000 phones per week and plans to increase output by 200 each week. Company B starts production with 500 phones per week and plans to increase output by 20% each week. (a) Calculate the weekly production in weeks 1; 5; 10; 15. Plot the graph of weekly output for each producer on the same diagram (use Excel, if available). Estimate the week in which the output is the same for both firms. (b) Calculate the total production during the first 15 weeks for each firm.
A certain faculty printer is shared by staff and students. Suppose that the rate of generating requests to the printer by staff is twice that of students, but that the average time to print a student printout is the same as average time for a faculty printout. If the utilization of the printer by the students is 25%, the utilization of the printer by the faculty is 50%, the overall average service time is 1 minute, what is the average time the students spend waiting for their printout (time spend in system)?
In 1993 the average expenditure of the employees on food and other items was as follows : In Cuttack In Bhubaneswar (i) Food 60% (ii) Other items 40% 50% 50% In 1998, the cost of living index was 279 for Cuttack and 265 for Bhubaneswar with 1993 as the base. The rise in price of all the items used by the employeees was known to be the same for both the towns. Determine the 1998 index for (i) food and (ii) other items.