Linear programming
A production & Inventory Problem
A company produces refrigerators, stoves, and dishwashers.
During thecoming year, sales are expected are:
QUARTER
PRODUCT
1
2
3
4
Refrigerators 1500 1000. 1500 1500
Stoves 1000 2000 2000 1200
Dishwashers 1200 1500 1500 2500
•The company needs a production schedule that meets the demand requirements.
•
•The inventory level for each product must be at least 150 units at the end of each quarter.
•
•There is no inventory of any product at the start of the first quarter.
•There are 21,000 hours of production time are available for each quarter.
•
•A refrigerator requires 3 hours, a stove 5 hours, and a dishwasher 4 hours ofproduction time.
•
•Refrigerators cannot be manufactured in the fourth quarter because the company plans to modify tooling for a new product line.
•
•Each item left in inventory at the end of a quarter incurs aholding cost of $5.
The company wants to plan its production schedule over the year in such a way that meets the quarterly demands and minimizes the total inventory cost.
Linear programming A production & Inventory Problem A company produces refrigerators, stoves, and dishwashers. During thecoming...
A company produces two types of refrigerators that use Freon gas for cooling. Each type A refrigerator sells for $2000, costs $1500 to manufacture, and leaks 15 grams of Freon. Each type B refrigerator sells for $1700, costs $1400 to manufacture, and leaks 5 grams of Freon. The following constraints exist: According to environmental codes, the total average Freon leakage of all refrigerators produced in next three years must not exceed 10 grams per refrigerator. Manufacturing capacity limits total refrigerator...
1) FreezyBreeze Company produces two types of refrigerators that use a special gas for cooling. Each type A refrigerator sells for $2000, costs $1500 to manufacture, and leaks 15 grams of gas . Each type B refrigerator sells for $1700, costs $1400 to manufacture, and leaks 5 grams of gas. The following constraints exist: The total average gas leakage of all refrigerators produced in next three years must not exceed 10 grams per refrigerator. Manufacturing capacity limits total refrigerator production...
Harvey Ltd. Produces three products: Fridges, Dishwashers and Washing machines. The company uses a single plant-wide factory overhead rate to all three products based on direct labour hours. The company currently uses plant-wide factory overhead allocation based on direct labour hours. The company also adds a 20% mark-up on the cost of production to cover administration cost and gross margin. The selling price per unit for the three products are as follows: Fridge - $1043.85 Dishwasher ...
O/ Write an appropriate mathematical model for this problem including Decision Variables and their description, Objective Function, & Constraints. XAMPLE 4.3 AGGREGATE PLANNING AT SURESTEP uring the next four months the SureStep Company must meet (on time) the fol lowing demands for pairs of shoes: 3000 in month 1 5000 in month 2; 2000 in month 3; and 1000 in month 4. At the beginning of month 1, 500 pairs of shoes are on hand, and SureStep has 100 workers....
Hello, I need help with the following problem: 1. Multi-period production problem. Formulate the production and inventory problem at XXI Company using Excel. See narrative below Solve the problem in Excel XX1 Company Production and Inventory Problem Narrative A company named XX1 has contracted to produce products A and B, over the months of June, July and August. The total production capacity (expressed in hours) varies monthly. The following table provides the basic data for the situation. June July August...
Solve and show work using excel. Problem 1. The pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. It has decided to use a six-month planning horizon. The forecasted demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5,000 footballs in inventory and it can use a given month’s production to help meet the demand for that...
Can someone help with this. The Master Budget 1. Sales Budget 2. Production Budget Texas Rex sells t-shirts. Expected sales for each quarter is 1000, 1200, 1500, and 2000 t-shirts at $10.00 each. They anticipate no price change. Texas Rex, Inc. Sales Budget For the year ending December 31, 2018 Q1 Q2 Q3 Q4 Total Units Unit Selling Price _______ _______ ________ _______ ________ Budgeted Sales A production budget tells management how many units must be produced to satisfy...
Problem 4-19 (Algorithmic) 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 220 men’s and 170 women’s models to be shipped during the second month. Additional data...
How do I calculate the one time adjustment of workforce to support the level production plan? Problem information: Month: 1 2 3 4 5 6 7 8 9 10 11 12 Demand: 500 800 1000 1400 2000 3000 2700 1500 1400 1500 2000 1200 Management at the Kerby Corporation has determined the following aggregated demand schedule in Units. An employee can produce an average of 10 units per month. Each worker on the payroll costs $2,000 in regular time wages...
Company AAA produces only one product which other manufacturers purchase as a component for their final products. The operations manager wants to plan the production and inventory quantities of the product for the first six months of the next year. The monthly demand is forecasted as follows. January February March April May June 1200 1400 1800 2400 2600 2200 The company has three production options: regular production, overtime production, and subcontracting. Production cost per unit during regular time is $80...