Design a production plan for Mamas Stuffin in Problem 14-4 using linear programming and Excel Solver. a)
Question:
Design a production plan for Mama’s Stuffin’ in Problem 14-4 using linear programming and Excel Solver.
Transcribed Image Text:
a) Annual demand= 36,000 pallets Average annual demand = 36,000/12= 3,000 Total number of workers needed =3000/200 = 1 workers Extra workers needed= 15-10= 5 workers DEMAND FORECAST 2000 1000 1000 1000 1000 1500 2500 3000 9000 7000 4000 3000 36,000 MONTH 1 2 3 4 5 6 7 8 9 10 11 12 TOTAL PRODUCTION PLAN 3000 3000 3000 3000 3000 3000 3000 3000 3000 3000 3000 3000 36,000 Total cost (Demand forecast Regular production cost) +(Inventory Holding cost) +(No.of extra workers-Hiring cost) Total cost (36,000x $30)+(63,500 $2)+(55000) = $1,232,000 INVENTORY 1000 3000 5000 7000 9000 10,500 11,000 11,000 5000 1000 0 0 63,500
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 61% (18 reviews)
Input Beg Wkrs 10 Regular 30 Hiring 5000 Unitswkr 200 Ov...View the full answer
Answered By
Nazrin Ziad
I am a post graduate in Zoology with specialization in Entomology.I also have a Bachelor degree in Education.I posess more than 10 years of teaching as well as tutoring experience.I have done a project on histopathological analysis on alcohol treated liver of Albino Mice.
I can deal with every field under Biology from basic to advanced level.I can also guide you for your project works related to biological subjects other than tutoring.You can also seek my help for cracking competitive exams with biology as one of the subjects.
3.30+
2+ Reviews
10+ Question Solved
Related Book For
Operations Management Creating Value Along the Supply Chain
ISBN: 978-0470525906
7th Edition
Authors: Roberta S. Russell, Bernard W. Taylor
Question Posted:
Students also viewed these Management Leadership questions
-
Design a production plan for Slopes and Sleds in Problem 14-6 using linear programming and Excel Solver.
-
Design a production plan for Rowley Apparel in Problem 14-3 using linear programming and Excel Solver.
-
Design a production plan for FansForYou in Problem 14-5 using linear programming and Excel Solver.
-
What are four advantages of integrating AI technologies into decision support systems?
-
For m, n Z+, prove that if m pigeons occupy n pigeonholes, then at least one pigeonhole has [m - 1)/n[ + more pigeons roosting in it.
-
List the details of all rooms at the Grosvenor Hotel, including the name of the guest staying in the room, if the room is occupied.
-
The kinematic viscosity of a certain solvent system depends on the ratio of the two solvents and the temperature. Table B. 10 summarizes a set of experimental results. a. Fit a multiple linear...
-
Cellular telephone service has certainly become more important vis--vis wired telephone service over the past decade. Will this trend continue? How will the trend toward cellular service be affected...
-
What is the present value of the following future amount? $311,205 to be received 15 years from now, discounted back to the present at 5 percent, compounded annually.
-
Condensed financial data follow for E-Perform Ltd. E-Perform reports under ASPE. Additional information: 1. New equipment costing $85,000 was purchased for $25,000 cash and a $60,000 note payable. 2....
-
Midlife Shoes, Inc. is a manufacturer of sensible shoes for aging baby-boomers. The company is having great success, and although demand is seasonal, it is expected to increase steadily over the next...
-
The global sourcing department of Slopes and Sleds (see Problems 14-6 and 14-12) has located a company in China that can make S&S products for $9 a unit. Revise the production plan using Solver. How...
-
Consider the semiconductor wafer data in Table 2-1. Suppose that 10 wafers are selected randomly (without replacement) for an electrical test. Determine the following: (a) Probability that exactly 4...
-
Tony took out a $1,000,000 life insurance policy on his life 10 years ago. Last year, when the policy's interpolated terminal reserve was worth $400,000, Tony gave the policy to his son, Chuck. Tony...
-
Dilbert purchased a home 10 years ago, where he has lived ever since with his coworker Wally. He purchased the home for $100,000 and recently sold it for $600,000. How much of the gain must Dilbert...
-
Tiarne Osprey is employed as a barista at Duotone Caf. During the 2023 income year, Tiarne received the following amounts: Net Wages from Duotone (PAYGW of $8,000) $52,000 Tips from customers $ 1,000...
-
Ayayai Ltd. reviews its assets every fiscal year for potential asset impairments. In the current year Ayayai realizes through its impairment assessment that a specialized machine has a recoverable...
-
Keller Industries started business part way through the current year and prepares annual financial statements. Keller Industries currently pays $10,000 of salaries (wages) per week for a 5-day work...
-
What are some basic and complex measurements associated with digital marketing analytics?
-
An educational researcher devised a wooden toy assembly project to test learning in 6-year-olds. The time in seconds to assemble the project was noted, and the toy was disassembled out of the childs...
-
A basic fundamental of computer safety is to avoid storing your password on a file in your computer because criminals will look there first. Your Task. Revise the following sentences to avoid...
-
At a point in Ohio, a manufacturer of hydraulic equipment (hoses, cylinders, and controls) consolidates the items on orders produced at various points in the United States. Consolidated orders are...
-
A distributor of truck and bus parts has a tie-down strap (B2162H) in inventory. The item has a monthly demand of 169 units with a standard deviation of 327 units per month, making the demand pattern...
-
Acme Computer maintains a stock of spare parts for the entire country at one warehouse in Austin, Texas. To provide improved customer service, the company will expand the number of warehouses to ten,...
-
Prob. 1(a). Consider a stock currently trading at $40.25. For a strike price of $38, you want to price both a call and put option that matures 90 days from now. The volatility of the stock (2) is...
-
Wildhorse sells a snowboard, WhiteOut, that is popular with snowboard enthusiasts. Presented below is information relating to Wildhorse's purchases of WhiteOut snowboards during September. During the...
-
The following unadjusted trial balance is prepared at fiscal year-end for Nelson Company. Nelson Company uses a perpetual inventory system. It categorizes the following accounts as selling expenses:...
Study smarter with the SolutionInn App