duction to Operations and Supply Chain Ma1.2, Tried and True's accountant (from Problem 1.1) suggests thatmonthly rent and hourly wage rate also be factored into the produc-tivity calculations. Annandale pays the highest average wage at $15 anhour. Blacksburg pays $10 an hour, Charlottesville $9, and Danville$8.50. The cost to rent store space is $2,800 a month in Annandale,$1,200 a month in Blacksburg, $2,000 a month in Charlottesville, and$800 a month in Danville.a. Which store is most productive?b. Tried and True is not sure it can keep all four stores open.Based on multifactor productivity, which store would you close?What other factors should be considered? Problems1.1. Tried and True Clothing has opened four new stores in collegetowns across the state. Data on monthly sales volume and laborhours are given below. Which store location has the highest laborproductivity?StoreAnnandale Blacksburg CharlottesvilleDanvilleSales volume$40,000$12,000$60,000$25,000Labor hours25060500200

Given- Store Annandale Blacksburg Charlottesville Danville Sales volume $40,000 $12,000 $60,000…

Answered: 1.2) Tried and True's accountant (from…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

please help me with Question 3 thanks! Demand forecasts for 2021 are as follows: Month Demand Jan 140,000 Feb 78,900 Mar 85,800 Apr 89,100 May 123,600 Jun 136,350 Jul 120,450 Aug 106,950 Sep 121,950 Oct 135,750 Nov 87,000 Dec 93,300 Each worker can produce 900 products per month and is paid $1500 per month. Assume that at the end of last year, the company has 100 employees working on the production line. Hiring and layoff (firing) decisions are made at the beginning of each month, and associated costs are charged at that time. It costs the company $400 to hire and $800 to lay off a worker. The company incurs holding cost for the amount of ending inventory in each month, and incurs backorder cost at the end of each month for any unfilled orders. The company incurs $2 per month for holding one unit in inventory and $4 per unit backorder. 1 Prepare a level aggregate plan. Under this level aggregate plan, how…
Demand 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?
4GE 10:01 A company has production costs of item and can produce 270 $15 per items for a total cost of $6,925. The company brings in a total of $3,995 in revenue from selling 85 of these items. Determine each of the following functions. Enter all answers below in slope-intercept form, using exact numbers. a. Find the company's linear revenue function. R(x) b. Find the company's linear profit function. P(x) Submit answer
The annual sales of Crimson Pharmacy are expected to be given by S = 2.5 + 0.4t million dollars t years from now, whereas the annual sales of Cambridge Pharmacy are expected to be given by S = 1.2 + 0.8t million dollars t years from now. When will Cambridge's annual sales first surpass Crimson's annual sales?
Hickory Manufacturing Company forecasts the following demand for a product (in thousands of units) over the next five years. Year 1 2 3 4 5 Forecast demand 62 84 86 90 90 Currently the manufacturer has seven machines that operate on a two-shift (eight hours each) basis. Thirty days per year are available for scheduled maintenance of equipment with no process output. Assume there are 250 workdays in a year. Each manufactured good takes 20 minutes to produce. What is the effective capacity of the factory? Round your answer down to the nearest whole number. units/year Given the five-year forecast, how much extra capacity is needed each year? Use a minus sign to enter an answer, if there is excess capacity. Round your answers to the nearest whole number. Year 1 2 3 4 5 Extra capacity needed (units) Does the firm need to buy more machines? If so, how many? When? If your answer is zero, enter "0". Round your answers up to the nearest whole number.…
A service company is considering whether or not it should outsource its delivery services. The service company employs 400 workers at an average annual wage of $22,000 plus another 39% for fringe benefits. Annual fixed costs associated with delivery services are $1,500,000. A transportation company will provide similar services for a fixed annual cost of $7,500,000 plus a variable cost of $21,000 per employee required. The transportation company would need only 90% of the current employees at the service company. What are the annual costs of using its current staff at the service company and transportation company? What would your final decision be for the service company?
Below is data of lobster sales volume from a seafood company. We are using exponential smoothing (α = 0.5) and 3-year moving average to forecast it. a. Please fill the blanks above and write your processes below. b. What are the mean absolute deviations (MADs) of the two methods? Whichmethod will you choose based on the results? *Please solve for a-b and type or write all your work/steps and answers on paper* NO EXCEL, thank you
Hickory Manufacturing Company forecasts the following demand for a product (in thousands of units) over the next five years. 1 2 3 4 5 86 90 Year Forecast demand Currently the manufacturer has seven machines that operate on a two-shift (eight hours each) basis. Thirty days per year are available for scheduled maintenance of equipment with no process output. Assume there are 250 workdays in a year. Each manufactured good takes 20 minutes to produce. a. What is the effective capacity of the factory? Round your answer down to the nearest whole number. units, year b. Given the five-year forecast, how much extra capacity is needed each year? Use a minus sign to enter an answer, if there is excess capacity, Round your answers to the nearest whole number. Year 1 Additional machines needed 2 1 24 Extra capacity needed (units) C. Does the firm need to buy more machines? If so, how many? When? If your answer is zero, enter "0". Round your answers up to the nearest whole number. 4 3 4 5 PE
Time period Actual sales 1 18 2 22 If the forecasting value of period 3 is 19.6 using exponential smoothing, the smoothing constant is what?
Please include an excel sheet showing calculations

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS