Cessna Aircraft makes among other things, single engine propeller driven aircraft. Each airplane requires two wheels. These wheels are made in batches, and then stored until they are needed for aircraft production. Each year, 2,000 aircraft are produced, meaning 4,000 wheels are needed. The factory operates 250 days per year, and the usage rate is the same each operating day. When a batch of wheels are produced, setup cost are $800, and 100 wheels can be made in a day. Holding cost are $20 per wheel per year. Use the information above to calculate: Economic Production Quantity (EPQ), cycle time, and run time (please do this in Excel using formulas). Also briefly, (1-2 sentences) explain what these three values mean.

Cessna Aircraft makes among other things, single engine propeller driven aircraft. Each airplane requires two wheels. These wheels are made in batches, and then stored until they are needed for aircraft production. Each year, 2,000 aircraft are produced, meaning 4,000 wheels are needed. The factory operates 250 days per year, and the usage rate is the same each operating day. When a batch of wheels are produced, setup cost are $800, and 100 wheels can be made in a day. Holding cost are $20 per wheel per year. Use the information above to calculate: Economic Production Quantity (EPQ), cycle time, and run time (please do this in Excel using formulas). Also briefly, (1-2 sentences) explain what these three values mean.

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

Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?
A firm making snowblowers produces the augers for each snowblower in batches. Annual demand is for 3,000 snowblowers, which means 3,000 augers need to be produced each year. On a given workday, 10 augers are needed for snowblower production. Annual holding costs are $3 per auger. Before the augers are produced, a setup cost of $100 is incurred to setup the equipment to produce a batch of augers. The firm can produce 50 augers per day. Given this information, find the economic production quantity for the auger units. Note: When doing interim calculations, round value to 2 decimal points.
The Tiny Toy Company makes three types of new toys: the tiny tank, the tiny truck, and the tiny turtle. Plastic used in one unit of each is 1.5, 2.0 and 1.0 pounds, respectively. Rubber for one unit of each toy is 0.5, 0.5, and 1.0 pounds, respectively. Also, each tank uses 0.3 pounds of metal, and the truck uses 0.6 pounds of metal during production. The average weekly availability for plastic is 16,000 pounds, 9,000 pounds of metal, and 5,000 pounds of rubber. It takes two hours of labor to make one tank, two hours for one truck, and one hour for a turtle. The company allows no more than 40 hours a week for production (priority #1). Finally, the cost of manufacturing one tank is $7, 1 truck is $5 and 1 turtle is $4; a target budget of $164,000 is initially used as a guideline for the company to follow. a) Minimize over-utilization of the weekly available supply of materials used in making the toys and place twice as much emphasis on the plastic (priority #2) b) Minimize the…
The Tiny Toy Company makes three types of new toys: the tiny tank, the tiny truck, and the tiny turtle. Plastic used in one unit of each is 1.5, 2.0 and 1.0 pounds, respectively. Rubber for one unit of each toy is 0.5, 0.5, and 1.0 pounds, respectively. Also, each tank uses 0.3 pounds of metal and the truck uses 0.6 pounds of metal during production. The average weekly availability for plastic is 16,000 pounds, 9,000 pounds of metal, and 5,000 pounds of rubber. It takes two hours of labor to make one tank, two hours for one truck, and one hour for a turtle. The company allows no more than 40 hours a week for production (priority #1). Finally, the cost of manufacturing one tank is $7, 1 truck is $5 and 1 turtle is $4; a target budget of $164,000 is initially used as a guideline for the company to follow. Minimize over-utilization of the weekly available supply of materials used in making the toys and place twice as much emphasis on the plastic (priority #2) Minimize the under and…
The Tiny Toy Company makes three types of new toys: the tiny tank, the tiny truck, and the tiny turtle. Plastic used in one unit of each is 1.5, 2.0 and 1.0 pounds, respectively. Rubber for one unit of each toy is 0.5, 0.5, and 1.0 pounds, respectively. Also, each tank uses 0.3 pounds of metal and the truck uses 0.6 pounds of metal during production. The average weekly availability for plastic is 16,000 pounds, 9,000 pounds of metal, and 5,000 pounds of rubber. It takes two hours of labor to make one tank, two hours for one truck, and one hour for a turtle. The company allows no more than 40 hours a week for production (priority #1). Finally, the cost of manufacturing one tank is $7, 1 truck is $5 and 1 turtle is $4; a target budget of $164,000 is initially used as a guideline for the company to follow. a) Minimize over-utilization of the weekly available supply of materials used in making the toys and place twice as much emphasis on the plastic (priority #2) b) Minimize the under…
Bag Company produces leather jackets and handbags. A jacket requires of leather and a handbag only . The labor requirements for the two products are 12 and 5 hours respectively. The current weekly supplies of leather and labor are limited to and 1,850 hours. The company sells the jackets for $350 and the handbags for $120. The objective is to determine the production schedule that maximizes the net revenue. In this document, write the mathematical formulation of both the primal and the dual problems. In the Excel file used in problem 1, solve the primal problem and generate a Solver sensitivity report in a new worksheet. In this document, use the Solver sensitivity report to answer the following two questions: What is the maximum purchase price the company should pay for additional leather? What is the maximum amount the company should pay for additional labor?
(Need both parts a and b) During the next four months, a customer requires, respectively, 500, 650, 1000, and 700 units of a commodity, and no backlogging is allowed (that is, the customer’s requirements must be met on time). Production costs are $50, $80, $40, and $70 per unit during these months. The storage cost from one month to the next is $20 per unit (assessed on ending inventory). It is estimated that each unit on hand at the end of month 4 can be sold for $60. Assume there is no beginning inventory. A. What is the objective function in this problem? B. What are the constraints in this problem? Write algebraic expressions for each
A company produces three different products; x,y, and z. For the production of 1 unit of product x, 1 unit of A and 1 unit of B are used as input. 1 unit of A and 2 units of B are used to produce 1 unit of product y. To produce 1 unit of product z, only 1 unit of A is used. The company holds 40 units of A and 20 units of B periodically in total. By the way, the company can not produce product y more than the twice of product z. On the other hand, the sale price of 1 unit of product x is 10 TL, product y is 15 TL and product z is 12 TL. Furthermore, the cost of 1 unit of product x is 8 TL, product y is 9 TL and product z is 7 TL. According to above information, what should be the company’s optimal product mix to maximize its profit? Construct the problem as a Linear programming model. Solve the above problem by using Simplex Method.
Tiny Toy Company makes three types of new toys: the tiny tank, the tiny truck, and the tiny turtle. Plastic used in one unit of each is 1.5, 2.0 and 1.0 pounds, respectively. Rubber for one unit of each toy is 0.5, 0.5, and 1.0 pounds, respectively. Also, each tank uses 0.3 pounds of metal, and the truck uses 0.6 pounds of metal during production. The average weekly availability for plastic is 16,000 pounds, 9,000 pounds of metal, and 5,000 pounds of rubber. It takes two hours of labor to make one tank, two hours for one truck, and one hour for a turtle. The company allows no more than 40 hours a week for production (priority #1). Finally, the cost of manufacturing one tank is $7, 1 truck is $5 and 1 turtle is $4; a target budget of $164,000 is initially used as a guideline for the company to follow. Minimize over-utilization of the weekly available supply of materials used in making the toys and place twice as much emphasis on the plastic (priority #2) I understand…
A poultry farmer in Lufyanyama has obtained a loan from the Bank to boost his poultry business. He provides you with data to help him optimize the sales. The data is that Old hens can be bought for K20 each but young one cost K50 each. The old hens lay 30 eggs per week, and young ones 50 eggs per week, each egg being worth 30ngwee. A hen cost K10 per week to feed. If a person has only K800 to spend on hens, how many of each kind should he buy to get a profit of more than K600 per week assuming that he cannot house more than 200 hens? a) Formulate the problem as a linear programming model b) Using the Big M – method, how many hens should he buy of each kind to maximize the profit per week? c) Identify the binding and non-binding constraints and justify your choice
A manufacturing process has 12 workers and 6 stations. The process iscompleted in the order given below. Where there are multiple workers within a station,each worker works independently on his/her own unit. Assume inventory buffers areallowed between each station.Station Staffing Processing time (hoursper unit per worker)A 2 2.20B 1 1.25C 3 2.00D 2 2.60E 3 3.00F 1 0.75What is the maximum number of units per hour that can be produced? Assume they startthe day with inventory at each station to work on
The Deeper Furniture makes two products: table and chairs, which must be processed through the assembly and finishing departments. Assembly department is available for 60 hours and in every production period, while the finishing department is available for 48 hours of work. Manufacturing one (1) table requires 4 hours in the assembly and 2 hours in the finishing. Each chair requires 2 hours in the assembly and 4 hours in the finishing. One table contributes P180 to profit, while a chair contributes P100. The problem is to determine the number of tables and chairs to make per production period in order to maximize the profit. Determine the following: A. Define the objective function, formulate the constraints, and graph the system.B. Determine and write the feasible comer points and corresponding profit and the optimal solution. OWN SOLUTIONS FOR UPVOTE. DO NOT USE AI OR ELSE DOWNVOTE.