Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences)
12th Edition
ISBN: 9781259580093
Author: William J Stevenson
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 13, Problem 42P
A Las Vegas supermarket bakery must decide how many wedding cakes to prepare for the upcoming weekend. Cakes cost $33 each to make, and they sell for $60 each. Unsold cakes are reduced to half-price on Monday, and typically one-third of those are sold. Any that remain are donated to a nearby senior center. Analysis of recent demand resulted in the following table:
How many cakes should be prepared to maximize expected profit?
a. Use the ratio method.
b. Use the tabular method (see Table 13.3).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
a. How much should be produced each period?
b. What is ending inventory for each period?
c.
If inventory carrying cost is $3 per case per period based on ending inventory, what is the total
cost of carrying inventory?
d. What is the total plan cost and why?
4. The opening backlog is 1200 units. Forecast demand is shown below.
a. Calculate the weekly production for level production if the backlog is to be reduced to
1000 units,
b. Calculate the projected backlog for each week.
Week
2
4
3
1200
1200
Forecast 1200
Demand
Planned
Production
Projected
Backlog
1200
1100
5
1100
25
20
6
1000
Total
5. A firm plans to make 400 wagons, 200 carts, and 100 sleds. The resource bill shown below
displays the amount of critical resources needed to make one average unit of product family:
Wood (Board Feet)
Labor (Standard Hours)
Product
Wagon
0.75
0.50
1.00
Cart
Sled
30
Calculate the total wood AND labor needed to make the total number of items in the product
family.
An electric hand drill would take 15, 40, 10, 20, 50, and 30 units in the next 6 weeks. The marketing department has booked orders for the first, second, third, and fourth weeks for 20, 25, 10 and 20 units in all. Currently, there are 30 hand boxes in order. The strategy should be ordered in several 60 units. One week is lead period. Lead time.
A. Develop the MPS hand drill log.
b. A hand drill dealer puts an order for 15 units. What is the correct date of shipment for the whole order?
We learned how to create Pivot Tables, Calculations, and Slicers. Using the data below:
Part A - Create a Pivot table that shows in aggregate form the Product, Average Number of Units sold (0 decimals), Total Sales (2 decimals), and % of Total Sales (1 decimal). Insert a Timeline by Months.
Part B - Create a Pivot table that shows in aggregate form the Products in the rows, the Locations in the Columns, and the Number of Transactions (not Units) for each. (0 decimals)
Group the Products eye liner and mascara and rename it "eye products" and Group the Products lip gloss and lipstick and rename it "lip products". Tum off all Subtotals (see Design menu).
Part C - Create a Pivot table that shows in aggregate form the Salesperson in the rows, the Location in the Columns, and the Average Total Sales (2 decimals) for each.
Then create a Pivot Chart in the form of a Line Chart with Markers making the x axis Products and they axis Average Total Sales with a Line for each Location. The y axis…
Chapter 13 Solutions
Loose-leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences)
Ch. 13 - What are the primary reasons for holding...Ch. 13 - What are the requirements for effective inventory...Ch. 13 - Briefly describe each of the costs associated with...Ch. 13 - What potential benefits and risks do RFID tags...Ch. 13 - Prob. 5DRQCh. 13 - Prob. 6DRQCh. 13 - a. List the major assumptions of the EOQ model. b....Ch. 13 - Explain briefly how a higher carrying cost can...Ch. 13 - What is safety stock, and what is its purpose?Ch. 13 - Prob. 10DRQ
Ch. 13 - What is meant by the term service level? Generally...Ch. 13 - Describe briefly the A-B-C approach to inventory...Ch. 13 - The purchasing agent for a company that assembles...Ch. 13 - Explain how a decrease in setup time can lead to a...Ch. 13 - What is the single-period model, and under what...Ch. 13 - Can the optimal stocking level in the...Ch. 13 - Prob. 17DRQCh. 13 - What trade-offs are involved in each of these...Ch. 13 - Who needs to be involved in inventory decisions...Ch. 13 - How has technology aided inventory management? How...Ch. 13 - To be competitive, many fast-food chains began to...Ch. 13 - As a supermarket manager, how would you go about...Ch. 13 - Sam is at the post office to mail a package. After...Ch. 13 - Give two examples of unethical conduct involving...Ch. 13 - Prob. 1PCh. 13 - a. The following table contains figures on the...Ch. 13 - A bakery buys flours in 25-pound bags. The bakery...Ch. 13 - A large law firm uses an average of 40 boxes of...Ch. 13 - Garden Variety Flower Shop uses 750 clay pots a...Ch. 13 - A produce distributor uses 800 packing crates a...Ch. 13 - A manager receives a forecast for next year....Ch. 13 - A food processor uses approximately 27,000 glass...Ch. 13 - The Friendly Sausage Factory (FSF) can produce hot...Ch. 13 - A chemical firm produces sodium bisulfate in...Ch. 13 - A company is about to begin production of a new...Ch. 13 - Prob. 12PCh. 13 - A mail-order house uses 18,000 boxes a year....Ch. 13 - A jewelry firm buys semiprecious stones to make...Ch. 13 - A manufacturer of exercise equipment purchases the...Ch. 13 - A company will begin stocking remote control...Ch. 13 - A manager just received a new price list from a...Ch. 13 - A newspaper publisher uses roughly 800 feet of...Ch. 13 - Given this information: Expected demand during...Ch. 13 - Given this information: Lead-time demand = 600...Ch. 13 - Demand for walnut fudge ice cream at the Sweet...Ch. 13 - The injection molding department of a company uses...Ch. 13 - A company uses 85 circuit boards a day in a...Ch. 13 - One item a computer store sells is supplied by a...Ch. 13 - The manager of a car wash received a revised price...Ch. 13 - A small copy center uses five 500-sheet boxes of...Ch. 13 - Ned's Natural Foods sells unshelled peanuts by the...Ch. 13 - Regional Supermarket is open 360 days per year....Ch. 13 - A service station uses 1,200 cases of oil a year....Ch. 13 - Caring Hospital's dispensary reorders doses of a...Ch. 13 - A drugstore uses fixed-order cycles for many of...Ch. 13 - Prob. 32PCh. 13 - Prob. 33PCh. 13 - Demand for jelly doughnuts on Saturdays at Don's...Ch. 13 - A public utility intends to buy a turbine as part...Ch. 13 - Skinner's Fish Market buys fresh Boston bluefish...Ch. 13 - A small grocery store sells fresh produce, which...Ch. 13 - Demand for devil's food whipped-cream layer cake...Ch. 13 - Prob. 39PCh. 13 - Demand for rug-cleaning machines at Clyde's...Ch. 13 - A manager is going to purchase new processing...Ch. 13 - A Las Vegas supermarket bakery must decide how...Ch. 13 - Offwego Airlines has a daily flight from Chicago...Ch. 13 - UPD Manufacturing produces a range of health care...Ch. 13 - Prob. 1.2CQCh. 13 - Prob. 2.1CQCh. 13 - Grill Rite is an old-line company that started out...Ch. 13 - SARAH LUBBERS AND CHRIS RUSCHE, GRAND VALLEY STATE...Ch. 13 - SARAH LUBBERS AND CHRIS RUSCHE, GRAND VALLEY STATE...Ch. 13 - Prob. 4.3CQCh. 13 - SARAH LUBBERS AND CHRIS RUSCHE, GRAND VALLEY STATE...Ch. 13 - Prob. 4.5CQCh. 13 - Prob. 1OTQCh. 13 - Prob. 2OTQCh. 13 - Prob. 3OTQCh. 13 - Prob. 4OTQ
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?arrow_forwardScenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. Ethical decisions that affect a buyers ethical perspective usually involve the organizational environment, cultural environment, personal environment, and industry environment. Analyze this scenario using these four variables.arrow_forwardScenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What should Sharon do in this situation?arrow_forward
- Wal Mart, although they are not a manufacturing company, uses sophisticated computer software to forecast sales and order products to be stocked in their stores so that they do not run out of the things shoppers are looking for. What kind of software system does Wal Mart likely use? Group of answer choices a) Inventory control b) Just-in-time ordering c) E-procurement d) Materials Requirement Planning (MRP)arrow_forwardA Pizza Company has a demand forecast for the next 12 months that is shown in Table 1 The current workforce of 100 staff can produce 1500 cases of pizzas per month. (a) Prepare a production plan that keeps the output level. How much warehouse space would the company need for this plan? (b) Prepare a demand chase plan. What implications would this have for staffing levels, assuming that the maximum amount of overtime would result in production levels of only 10 per cent greater than normal working hours? Table 1 demand forecast Month Demand (cases per month) January 600 February 800 March 1000 April 1500 May 2000 June 1700 July…arrow_forwardplease answer within 30 minutes. its urgent.arrow_forward
- Deforrest Marine Motors manufactures engines for the speedboat racing circuit. As part of their annual planning cycle, they forecasted demand for the next four quarters. The number of available days of production and the anticipated demand are given below. Employees Production Rate Production Cost Backorder Cost Overtime Cost Overtime Limit Demand Q1 2,400 6,019,000 They also estimated many of the costs required to conduct operations planning. Some of these key figures are listed below. 30 70 units/employee/quarter Q2 2,200 $1,000/unit $200/unit/quarter $1,500/unit <= 25% of Reg. Production Q3 1,700 Q4 1,800 Hire Cost Fire Cost Subcontracting Cost Subcontracting Limit Inventory Cost Initial Inventory $1,200/employee $800/employee $1,800/unit 400 units maximum $100/unit/quarter 280 units Deforrest Marine Motors wishes to maintain the current number of employees for the entire year to follow a level strategy balanced with inventory and backorders as needed. What is the total cost of this…arrow_forwardOnly the blanks in A, B and D please.arrow_forwardWhich of the following is not one of the graphical methodsteps?a) Determine the demand in each period.b) Determine capacity for regular time, overtime, andsubcontracting each period.c) Find labor costs, hiring and layoff costs, and inventoryholding costs.d) Construct the transportation table.e) Consider company policy that may apply to the workers or stock levels.f ) Develop alternative plans and examine their total costs.arrow_forward
- The following information has been extracted from the cost information system of Kevianmanufacturers ltd for the last 12 weeks in the year ended 31st December 2020 Required:a) Using the high-low cost estimation method develop a cost estimation function for Production department Overhead Cost using the Machine hours as the activity level. b) The actual Production Department Overhead Cost in week 12 from above is 963,000. Using the machine hours of 48, direct labour hours of 38 from week 12 explain which of the two cost functions developed above is more accurate. c)Calculate and interpret the coefficient of Determination (R^2) using the cost estimation function derived using the Machine hours as the activity level.arrow_forward19) What is the EBM, if total basic employment is 128,500 and total employment is 350.000? 20) What does the EBM indicate in question 19? 21) Based on question 19, If the population is 798,112, what is the PER. 22) What does the PER indicate?arrow_forwardplease 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…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational PublishingPurchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
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
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY