Question

In: Operations Management

The Waikiki Enterprise Corporation produces two types of computers at its manufacturing plant in Torrance, California.

Topic: Economic Order Quantity


Determine the Economic Order Quantity in Excel for:
Price of Product: $150
Savings Rate: 12%
Annual Usage: 16240
Cost of transportation: $200/order
Cost of PO preparation: $60/order
Warehouse Rental: $8/piece

Topic: Linear Programming


Develop problem 1 of chapter 8 using excel or by hand. You need to present the objective and constraints equations. No need to solve it.

The Waikiki Enterprise Corporation produces two types of computers at its manufacturing plant in Torrance, California. Profit on computers A is $900 per unit and for computer B it is $600. The manufacturing plant can produce not more than 50 of computer A and 100 of computer B a day. The following table displays the capacity for the manufacturing plant.

a) What are the decision variable?

b) What is the objective function?

c)What are the constraints?

d)What are the non-negativity assumptions?

Spreadsheet Modeling for Business Decisions Third Edition Revised for Excel 2010 byJohn F. Kros. Chapter8.2

Word and Excel

Solutions

Expert Solution

Linear Programming

1. Decision Variable -

X : no of units produced of computor A

Y: no of units produced of computor B

2. Objective Function

Objective is to have maximim profit

Maximize: 900 * X + 600 * Y

3. Constraints-

Production capacity of computor A:   X <= 50

Production capacity of computor B:   Y <= 100

d) Non-negativity assumption

Production of computor will not be negative

X >= 0

Y >= 0


Related Solutions

Rundle Manufacturing produces two keyboards, one for laptop computers and the other for desktop computers. The...
Rundle Manufacturing produces two keyboards, one for laptop computers and the other for desktop computers. The production process is automated, and the company has found activity-based costing useful in assigning overhead costs to its products. The company has identified five major activities involved in producing the keyboards. Activity Allocation Base Allocation Rate Materials receiving & handling Cost of material 2 % of material cost Production setup Number of setups $ 108.00 per setup Assembly Number of parts $ 6.00 per...
Rundle Manufacturing produces two keyboards, one for laptop computers and the other for desktop computers. The...
Rundle Manufacturing produces two keyboards, one for laptop computers and the other for desktop computers. The production process is automated, and the company has found activity-based costing useful in assigning overhead costs to its products. The company has identified five major activities involved in producing the keyboards. Activity Allocation Base Allocation Rate Materials receiving & handling Cost of material 2 % of material cost Production setup Number of setups $ 108.00 per setup Assembly Number of parts $ 6.00 per...
Franklin Manufacturing produces two keyboards, one for laptop computers and the other for desktop computers. The...
Franklin Manufacturing produces two keyboards, one for laptop computers and the other for desktop computers. The production process is automated, and the company has found activity-based costing useful in assigning overhead costs to its products. The company has identified five major activities involved in producing the keyboards. Activity Allocation Base Allocation Rate Materials receiving & handling Cost of material 1 % of material cost Production setup Number of setups $ 113.00 per setup Assembly Number of parts $ 5.00 per...
Sunland Manufacturing produces two products in its Saratoga plant, balzene and galvene. Since it opened its...
Sunland Manufacturing produces two products in its Saratoga plant, balzene and galvene. Since it opened its doors in 1965, Sunland has been using a single manufacturing overhead pool to accumulate overhead costs. Overhead has been allocated to products based on direct labor hours. Until recently, Sunland was the sole producer of galvene in the country and was therefore able to dictate the selling price. However, last year Marcella Products began marketing a comparable product at $53 per unit—a price that...
Juguette's Boise plant produces two types of battery-operated toys: robots and race cars. The Boise plant...
Juguette's Boise plant produces two types of battery-operated toys: robots and race cars. The Boise plant uses a plantwide rate based on direct labor hours to assign its overhead costs. The company has the following estimated and actual data for the coming year: Estimated overhead $350,000 Expected activity (direct labor hours) 50,000 Actual activity (direct labor hours):     Robots 10,000     Race cars 40,000 Units produced:     Robots 50,000     Race cars 250,000 Calculate the predetermined plantwide overhead rate. Calculate...
Benton Corporation produces two grades of wine from grapes that it buys from California growers. It...
Benton Corporation produces two grades of wine from grapes that it buys from California growers. It produces and sells roughly 3,000,000 liters per year of a low-cost, high-volume product called CoolDay. It sells this in 600,000 5-liter jugs. Benton also produces and sells roughly 300,000 liters per year of a low-volume, high-cost product called LiteMist. LiteMist is sold in 1-liter bottles. Based on recent data, the CoolDay product has not been as profitable as LiteMist. Management is considering dropping the...
A manufacturing corporation has installed a plant and machinery in its factory as on 5th January,...
A manufacturing corporation has installed a plant and machinery in its factory as on 5th January, 2018. The purchase price of that plant and machinery was OMR 220,000 and on this price 8% of trade discount was included and 5% of rebates were included after deducting the trade discount. Initial delivery cost was OMR 12,500 in that 20% of which was handling cost of the whole machinery in the factory building. Cost of testing was OMR 7,500, professional fees to...
4. A manufacturing plant produces memory chips to be used in cardiac pacemakers.The manufacturing process produces...
4. A manufacturing plant produces memory chips to be used in cardiac pacemakers.The manufacturing process produces a mix of “good” chips and “bad” chips. The lifetime of good chips follows an exponential law with a rate of failure ??, that is: P[chip still functioning after time ?] = ?−?t The lifetime of bad chips also follows an exponential law, but with a much faster failure rate of 500*?. a. Suppose the fraction of bad chips in a typical batch is?.What...
Blend corporation produces two types of blenders. The blenders are produces using a special metal. Due...
Blend corporation produces two types of blenders. The blenders are produces using a special metal. Due to global supply chain problems, the supply of the metal is limited and Blend is able to obtain only 20,000 pounds. Which blender should Blend produce given the following information?                                                                                    Deluxe             Basic Unit Selling Price                                                       $95                   $75 Unit Variable Costs                                                   57                       45 Unit Contribution Margin                                          $38                     $30 Number of Pounds of metal per blender                  4                          2.5 Required Assume that there is no shortage...
California Circuits Company (3C) manufactures a variety of components. Its Valley plant specializes in two electronic...
California Circuits Company (3C) manufactures a variety of components. Its Valley plant specializes in two electronic components used in circuit boards. These components serve the same function and perform equally well. The difference in the two products is the raw material. The XL-D chip is the older of the two components and is made with a metal that requires a wash prior to assembly. Originally, the plant released the wastewater directly into a local river. Several years ago, the company...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT