Pennsylvania Replicas..... Pennsylvania Replicas makes two types of traditional Shaker tables: The Simplicity and the Workman.The two lines are made in the same facility using the same labor and equipment. In addition, we know that:Problem 1Each Simplicity and Workman table requires, on average, about 3.2 hours of labor.Each employee works 160 hours per month, and there is no effective limit on the number of employeesThe cost of hiring or firing an employee is$900The monthly holding cost for a table is$9.50For planning purposes, the beginning and ending workforce isAt the beginning of the planning period, there are 0 units in inventoryMonthNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJulyAugustSimplicityDemand474553WorkmanDemand632632790790948948102711064266497756885688711071108532853292439954Develop a level S&OP for November - August.Show aggregated monthly production, workforce and ending inventory levels;monthly hirings and firings; and total hiring, firing, and inventory costs.To keep it simple, assume you can have fractional units in inventory, and thatyou can hire / fire fractional numbers of employees (ex.-25.5 employees)22 employees

Find the Given details below: Given details: Month Simplicity Demand Workman Demand November…

Answered: Pennsylvania Replicas makes two types…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Suppose Firm A can manufacture 100 pens and 20 umbrellas with a unit of labor, and Firm B can manufacture 80 pens and 10 umbrellas with a unit of labor. Which one of the following statements is true? Firm A has the comparative advantage in both pen and umbrella production.Firm B has an absolute advantage in umbrella production.Firm A has a comparative advantage only in pen production.Firm B has a comparative advantage in pen production.Neither firm has a comparative advantage in either pen or umbrella production.
List the system of inequalities which describe B in the graph below.ECON1003 Mathematics for Social Sciences Unit 3_Version 1 Page 33 6. Anya’s Jeans has production process organized in threedistinct stages: cutting; sewing and finishing. She produces threetypes of jeans, namely peddle-pushers, hipsters and low cuts. Thenumber of minutes each type requires in each production processin shown below.Type Cutting Sewing FinishingPeddle-Pusher 4 6 2Hipster 6 7 4Low Rider 9 3 6On average, there are 6400 minutes of cutting time, 3500 minutes ofsewing time and 2400 minutes of finishing time each day. Given thatthe company makes $10 profit on each peddle-pusher $ 50 on eachhipster and $60 on each low cut and that the company sells all thejeans made. List the system of inequalities for the cutting, sewingand finishing constraints.
2.28 A foundry produces castings to order. An order for 20 special castings has been re- ceived. Since the casting process is highly variable, not all castings produced are good. The cost of producing each casting is $550; the additional cost of finishing a good casting is $125. If a casting is not good, it is recycled at a value of $75; excess good castings are not finished but are recycled at a value of $75. The customer has agreed to accept 15, 16, 17, 18, 19, or 20 castings at a price of $1250 each. If fewer than 15 good castings are produced, none will be purchased by the customer. Prob- ability distributions for the number of good castings produced in a batch of varying sizes are given below. How many castings should be scheduled in order to maximize expected profit? #Good Castings 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 79 2 PRODUCT, PROCESS, AND SCHEDULE DESIGN Number of Castings Scheduled 15 16 17 0.05 0.00 0.00 0.00 0.00 0.00 0.05 0.05 0.00…
A warehouse can store up to 100 units of a particular item. In each of the next N days weneed to determine the number of units to sell and then the number of units to buy. Sellingin each day precedes buying so that the maximum amount that can be sold is the initialinventory at the beginning of the day. The maximum amount that can be bought is limitedby the capacity minus the amount in inventory after selling takes place. Inventory can beheld overnight in the warehouse, provided the total number of units held does not exceed thewarehouse capacity. At the beginning of day 1, before selling takes place, there are 40 unitsof inventory in the warehouse. Suppose that pnand cnare the per unit selling and buyingprices, respectively, for each day n = 1, . . . , N . Formulate an LP in general form to determinethe amount to be sold and bought each day to maximize total profit. Make sure you havedefined your variables clearly. PLEASE provide steps on how you solved so I understand why the answer…
An airline studied the data from their passenger records and noted that their customers turn up only about 95% of the time. A flight can accommodate 40 passengers and each seat costs 4,000 Php. Suppose each passenger books a ticket independently and the airline decides to sell 42 tickets for the flight. If more than 40 show up for the flight , then the extra passengers will be compensated PhP10,000 for rebooking and other expenses. 5. If Profit = Ticket sales-Compensation of Bumped passenger(s). What is the profit if 42 customers show up?
Mack’s guitar fabrication shop produces low cost, highly durable guitars for beginners. Typically, out of the 100 guitars that begin production each month, only 80 percent are considered good enough to sell. The other 20 percent are scrapped due to quality problems that are identified after they have completed the production process. Each guitar sells for $300. Because some of the production process is automated, each guitar only requires 10 labor hours. Labor is paid at $10/hour, materials cost is $40/guitar, and overhead is $2,000. a) Calculate the labor and multifactor productivities. b) After some study, the operations manager recommends 3 options to improve the company’s multifactor productivity: (1) increase the sales price by 10 percent, (2) improve quality so that only 10 percent are defective, or (3) reduce labor, material, and overhead costs by 10 percent. Which option has the greatest impact on the multifactor productivity measure?
The Delta company uses three raw materials to make cakes. Delta is trying to reduce warehousing costs and establishes three policies to that end: i) The annual number of orders for all products must be at least 20 per contractual terms with transportation providers. ii) The average inventory in units must be a maximum of 1800. iii) Because the raw material is perishable, there can never be more than 2000 units in inventory of raw material 1. Raw material 2 has a maximum allowed of 1200 units and the raw material 3 can store maximum 400 units. The following table shows the product information: Materia Demanda Costos por unidad Costo por prima (u/año) ordenar ($) 2200 2 300 2 500 4 650 3 3000 10 100 Consider an interest rate of 10% per year. A) Formulate the problem as a mathematical programming model that minimizes the total annual cost. b) Represent the problem in a single equation including the constraints in terms of lambda c) Find the optimized batch sizes for the company's raw…
Please do not give solution in image format thanku In 2018, the government of Ghana launched operation one district one factory (IDIE). Based on IDIF, Ekumfi Pineapple Factory Co. Ltd (EPF) was launched. In 2019 the management of ERF started production with 100 workers per shift, each of the three shifts working 8 hours per day. Every working day the payroll cost was GHIC 20,000 and overhead expenses amounted to GHC 5000 and material cost GHC 4000. At the end of the first year, the company produced 1,000,000 boxes of pineapple juice. During the second year, EPF acquired a loan from Exim Bank to purchase a new plant. After the introduction of the new plant, the management reduced the size of its workers per shift to 80, each working 8 hours per day, with the payroll cost reducing to GHC 18,000 and overhead expenses also reducing to GHC 4000 and material cost rising to GHC 6000. Production rose to 1,200,000 boxes. Regard yourself as the Operations Manager of EPF: a) What are the…
Mary hopes to sell 10,000 pieces of chrysanthemum last November but she was able to sell 15,000 chrysanthemum. Her chrysanthemum is sold at 20 pesos each. Her total expenses was 150,000, hence, cost per unit is 15.00. What was her sales volume? * 300,000 150,000 10,000 O 25,000 O 15,000
13) Which of the following method is used for calculating Time value of Money? a. Future Value b. All of the options c. Annuity method d. Present value
2. The idea of assigning numerical values to determine a preference ordering over a set of ob- jects is not limited in application to commodity bundles. The Bill James Baseball Abstract argues that a baseball player's batting average is not an adequate measure of his offensive productivity. Batting averages treat singles just the same as extra base hits. Furthermore they do not give credit for "walks," although a walk is almost as good as a single. James argues that a double in two at-bats is better than a single, but not as good as two singles. To reflect these considerations, James proposes the following index, which he calls "runs created." Let A be the number of hits plus the number of walks that a batter gets in a season. Let B be the number of total bases that the batter gets in the season. (Thus, if a batter has S singles, W walks, D doubles, T triples, and H home runs, then A= S + D + T + H+W and B = S +W +2D +3T +4H.) Let N be the number of times the batter bats. Then his…
In the spreadsheet model shown below, an analyst makes the following data entries. Cell ВЗ В4 В5 B6 Value 113,000 90,000 119,000 99,000 A 1 Revenue 2 Month Revenue Change (%) n/a =(B4-B3)/B3 =(B5-B4)/B4 =(B6-B5)/B5 3 January 4 February 5 March 6 April What values will be shown in the following cells? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Cell Value С4 % C5 C6 %

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS