Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. The following data were collected from last year’s operations (revenues and costs in thousands of dollars).
Store Revenues Costs
101 $4,120 $4,244
102 2,247 2,934
103 5,768 5,211
104 4,022 4,048
105 2,944 3,736
106 4,063 3,389
107 6,914 5,059
108 1,809 2,474
109 5,516 4,768
110 3,288 3,019
111 3,926 4,229
112 4,740 3,240
113 3,572 2,616
114 4,897 4,695
115 2,224 3,016
Simple regression results from the data of Davis Stores are as follows.
Equation:
Store costs = $1,684.0 + (Revenue x 53.2%)
Statistical data
Correlation coefficient 0.837
R2 0.701
Required A:
- Estimate store costs for a store with revenue of $2.7 million.
Estimate store costs for a store with revenue of $2.7 million. (Enter the answer in thousands of dollars. Round your answer to 2 decimal places.)
Store cost ____________________
Required B:
- What percentage of the variation in store costs is explained by the independent variable?
Percentage of variation in store cost ________________
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
- Given the following forecast and steady regular output of 550 every month, what total cost would result if overtime is limited to a maximum of 40 units a month, and subcontracting is limited to a maximum of 10 units a month? Unit costs are: Regular output $20 Overtime $30 Subcontract $25 Average Inventory $10 Backlog $18 Month 1 2 3 4 5 6 Forecast 540 540 570 590 650 680arrow_forwardSales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Year Sales 1 455 2 510 3 520 4 570 584 a) Forecasted sales for year 6 using a 3-year moving average is sales (round your response to one decimal place). b) The MAD for a 3-year moving average based forecast is sales (round your response to one decimal place). c) The MSE for a 3-year moving average based forecast is sales (round your response to the nearest whole питber).arrow_forwardA store’s demand figures are given in the table. According to this, what is the linear regression forecast for Week 12?arrow_forward
- Using the table, what is the paid occupancy percentage for the month? Month November Rooms in 300 Hotel Paid Rooms 5,497 Occupied 5,697 Rooms Paid Guests 5,948 Total Hotel $2,157,893 Revenue 63.30% 61.08% 59.11% 61.26%arrow_forwardThe number of internal disk drives (in millions) made at a plant in Taiwan during the past 5 years follows: F Year 4 Disk Drives 142 164 196 204 216 B a) Using simple linear regression, the forecast for the number of disk drives to be made next year-isk drives (round your response to one decimal place)arrow_forwardThe department at a local department store has tracked the sales of a product over the last ten weeks. Forecast demand using exponential smoothing with an alpha of 0.3, and an initial forecast of 30.0 for period 1. a. Calculate the MAD covering periods 2-10. b. Calculate the tracking signal covering periods 2-10. c. What do you recommend? Period (t) Demand (At) 1 24 2 23 3 26 4 36 5 26 6 30 7 32 8 26 9 25 10 28arrow_forward
- 10.3. The Ashton Furniture Company manufactures coffee tables and chests of drawers. Last year the company’s cost of goods sold was $3,700,000, and it carried inventory of oak, pine, stains, joiners, and brass fixtures, work-in-process of furniture frames, drawers and wood panels, and finished chests and coffee tables. Its average inventory levels for a 52-week business year were as follows: Raw Materials Average Inventory Unit Cost Oak 8000 $6.00 Pine 4500 4.00Brass fixtures 1200 8.00Stains 3000 2.00Joiners 900 1.00 Work-in-Process Frames 200 $30Drawers 400 10Panels 600 50Chests…arrow_forwarda. A manufacturing firm manufactures electric motors. The sales during the last four months (starting from the first month) has been: 96, 75, 89, and 68 units. The forecast for the first month was 80 units. Using the exponential smoothing method with a = .70, predict the next moth's sales. Calculate the mean absolute percent deviation for this data and comment on the performance of the forecasting method. b. Using the rule lot size=multiple of 50, determine the planned order releases for each week in the following MRP record. The lead time is 2 weeks. ISarrow_forwardSales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below) Year Sales 1 455 2 495 516 4 563 584 a) Forecasted sales for year 6 using a 3-year moving average is sales (round your response to one decimal place). b) The MAD for a 3-year moving average based forecast is sales (round your response to one decimal place). c) The MSE for a 3-year moving average based forecast is sales (round your response to the nearest whole number).arrow_forward
- 3. Answer the followings. a. Myanmar CP Live Stock Company Limited Shipped Sausage boxes around Myanmar. A manager wants to forecast shipments for the first four months of the next two years by using Linear equation method. The monthly forecast equation being used is: y= 402 + 3x and determine trend amounts for the first four months of the next two year: January, x=24, February, x=25; etc. b. A farm implements dealer is seeking a fourth warehouse location to complement three existing warehouses. There are three potential locations, N.C; Atlanta, Ga.; and Columbia, S.C. Charlotte would involve a fixed cost of $4,000 per month and a variable cost of $4 per unit. Atlanta would involve a fixed cost of $3,500 per month and a variable cost of $5 per unit; and Columbia would involve a fixed cost of $5,000 per month and a variable cost of $6 per unit. Use of the Charlotte location would increase system transportation costs by $19,000 per month. Atlanta by $22,000 per month, and Columbia by…arrow_forwardDemand at Nature Trails Ski Resort has a seasonal pattern.Demand is highest during the winter, as this is the peak ski season.However, there is some ski demand in the spring and even fallmonths. Th e summer months can also be busy as visitors oft encome for summer vacation to go hiking on the mountain trails.Th e owner of Nature Trails would like to make a forecast for eachseason of the next year. Total annual demand has been estimatedat 4000 visitors. Given the last two years of historical data, what isthe forecast for each season of the next year?arrow_forward8.11 The average demand for January has been 80, and the average annual demand has been 1800. Calculate the seasonal index for January. If the company forecasts annual demand next year at 2000 units, what is the forecast for January next year?arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.