Answered: Goal Seek does not calculate the output…

Business

Operations Management

Goal Seek does not calculate the output value that provides the desired input value.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 46P

See similar textbooks

Similar questions

Complete the following: Target Based Situation: Produce products within 30 days Objective: Limiting Factors: Target Based Situation: Budgeting of 1 million pesos Objective: Limiting Factors:
The forecasted demand for fudge for the next four months is 110, 140, 230, and 160 pounds. What is the recommended production rate if a level strategy is adopted with no backorders or stockouts? What is the ending inventory for month 4 under this plan? Round your answers to the nearest whole number. Production rate: pounds/month Ending inventory (month 4): pounds What is the level production rate with no ending inventory in month 4? Round your answer to one decimal place. Production rate: pounds/month
It is summertime and your winter coat factory is trying to decide its production schedule and staffing level for the next season. You are forecasting a demand of 5000 coats in October, 8000 coats in November, 8000 coats in December, 12000 coats in January, 12000 coats in February, and 9000 coats in March. You want to manufacture these coats at the lowest cost possible/ The first decision you need to make is how many people to hire. Each employee will cost $2500 a month. You don’t want to hire or fire any employees mid-season in order to minimize disruptions in your factory floor. You can have employees idle if there isn’t sufficient work for them to do. Employees still need to be paid even if they are idle. An employee works 20 business days a month and takes half a day to produce one coat. The employees can also be asked to work overtime, in which case you need to pay them $70 per coat they produce. You don’t need to assume there is any capacity constraint on the number of overtime…
It is summertime and your winter coat factory is trying to decide its production schedule and staffing level for the next season. You are forecasting a demand of 5000 coats in October, 8000 coats in November, 8000 coats in December, 12000 coats in January, 12000 coats in February, and 9000 coats in March. You want to manufacture these coats at the lowest cost possible/ The first decision you need to make is how many people to hire. Each employee will cost $2500 a month. You don’t want to hire or fire any employees mid-season in order to minimize disruptions in your factory floor. You can have employees idle if there isn’t sufficient work for them to do. Employees still need to be paid even if they are idle. An employee works 20 business days a month and takes half a day to produce one coat. The employees can also be asked to work overtime, in which case you need to pay them $70 per coat they produce. You don’t need to assume there is any capacity constraint on the number of overtime…
The ABC Company is making a production plan for the next year, given the sales forecast for the next year as: Quarter 1 2 3 4 Total Sales Forecast (units) 9,000 12,000 16,000 12,000 49,000 Currently, the ﬁrm has 12 employees, each producing up to 1,000 units per quarter and earning $2,000 per quarter. The ﬁrm estimates its inventory carrying cost to be $2 per unit of ending inventory per quarter and its hiring or layoff costs to be $1,600 per employee. The company currently has an inventory of 2,000 units and wishes to have an ending inventory of at least 1,000 units at the end of each quarter. The company does not plan to incur inventory shortages. Find the optimal production plan that minimizes the total cost by Excel solver
Case Synopsis: Mahindra & Mahindra Ltd., a $23 billion company in 2021, has been the number one tractormanufacturer in India for the last 30 years. The agriculture tractor sale market in India is seasonal in nature andgrowing. To meet demand, the company has four manufacturing plants and 26 sales offices across the country; theirmain job is to coordinate supplies between its 800 dealers and the company. The sales offices provide a rollingdemand forecast of tractors for the current month plus two months in the future. The forecast is used to determine thenumber and models of tractors to manufacture and to support advance ordering of key modules and parts. The deputygeneral manager of sales in the company’s Farm Division has been receiving an increasing number of complaints fromirate dealers about the supply of tractors from the company’s stockyards. He needs your help to fix the situation. 1A. Discuss two additional demand management strategies or tools that MMFE could use to better…
Use the table below to answer the following question(s). Fiberia Accessories, a clothing retailer, is planning to introduce a new line of sweaters as part of the winter collection for $65 with an inventory of 1500. The main selling season is 60 days between November and December. The store then sells the remaining units in a clearance sale at 65 percent discount. Out of the 60 main retail days, Fiberia sells the sweaters at full retail price for only 45 days, while giving a discount of 25 percent for the remaining 15 days. The demand functions a, and b are given as 79.5 and 1.1 respectively. Marked Down Pricing Model for Fiberia Accessories's new sweater Data Retail Price Inventory Selling Season (days) Days at Full Retail Intermediate Markdown Clearance Markdown Demand Function A B $65 1500 60 45 25 percent |65 percent 79.5 1.1 Compute the everyday sales throughout the discount sales period.
The Bango Toy Company produces several types of toys to seasonal demand. The forecast for the next six months in thousands of dollarsis given below:July Aug. Sept. Oct. Nov. Dec.Forecast $1000 $1500 $2000 $1800 $1500 $1000A regular employee can produce $10,000 worth of toys per month, and the company has 80 regular employees excel at the end of June. Regular-time employees are paid $3800 per month, including benefits. An employee on overtime produces at the same rate as on regular time but is paid at 150 percent of the regular pay. Up to 20 percent overtime can be used in any one month. A worker can be hired for $1000, and it costs $2000 to lay off an employee. Inventory carrying costs are 30 percentper year. The company wishes to end the year with 80 employees. Beginning inventory of toys is $900,000.a. Calculate the cost of a chase strategy.b. Calculate the cost of a level strategy.c. Using the Excel template, simulate several other strategies.d. Determine the effect on the chase…
The Silver Star Bicycle Company will be manufacturing both men's and women's models of its Easy-Pedal 10-speed bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 men's and 125 women's models to be shipped during the first month and 200 men's and 150 women's models to be shipped during the second month. Additional data are shown: Production Labor Requirements (hours) Current Model Costs Manufacturing Assembly Inventory Men's $120 2.0 1.5 20 Women's $90 1.6 1.0 30 Last month the company used a total of 1000 hours of labor. The company's labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of…
Chelsea Jacobson awaited the arrival of her bed and dresser one Saturday in September. She’dpurchased the items in the IKEA Brooklyn store twelve days before, and couldn’t wait to finally bedone with sleeping on the floor of her apartment. She needed to be well rested as she headed toher writing job in Hell’s Kitchen.Although she’d been given a delivery window for the furniture to arrive, her bed and dresser never came.She contacted the shipping company, XPO Logistics, to get an update on the status of her items, butXPO notified her that IKEA had never supplied the order. Jacobson contacted IKEA numerous timesand eventually found out it could take an additional 4-6 weeks for her items to arrive, as they had been misplaced.Jacobson joins the ranks of customers who have fallen victim to IKEA’s troubled customer service.After attempts to contact the company via email and phone proved unsuccessful, she turned toTwitter to voice her complaints and warn others, only to find thousands of…
Northwest Pipe (NP) makes water pipe. NP is planningproduction for the next seven months, March through September.Th e forecast demands (in thousands of feet) are, respectively, 40,60, 70, 80, 90, 100, and 80. NP can make 75,000 feet of pipe permonth using regular-time production, at a cost of $1.25 per foot.Th ey can make up to an additional 15,000 feet using overtimeproduction at a cost of $1.50 per foot. Any pipe made in onemonth and sold in a later month incurs an inventory holding costof $0.15 per foot, per month. NP expects to end February with5000 feet of pipe and would like to plan to end September with10,000 feet in inventory. NP would like to plan their productionschedule to minimize total cost during the next seven months. (a) Formulate an LP to minimize total costs.(b) Set up and solve the problem on a spreadsheet.(c) What is the optimal solution? Explain the rationale for thesolution
Eastman Publishing Company is considering publishing an electronic textbook on spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and Web site construction is estimated to be $160,000. Variable processing costs are estimated to be $6 per book. The publisher plans to sell access to the book for $46 each. a. Build a spreadsheet model to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3500 copies? b. Use a data table to vary demand from 1000 to 6000 increments of 200 to assess the sensitivity of profit to demand. c. Use Goal Seek to determine the access price per copy that the publisher must charge to break even with a demand of 3500 copies.