Your Manufacturing company has been tasked with building Televisions, computers, and microwaves. To makethese products, there are three sub components: Capacitors, Resistors, and Processors.Below shows the maximum number of Televisions, computers, and microwaves we can make along with themaximum number of capacitors, resistors, and processors available to make them.Your Revenue function is determined as $2 for every capacitor used, $3 for every resistor, and $25 for eachprocessor. However, there are FIXED costs if you decide to use the these. If you use Capacitors, it will have afixed cost of $50, Resistors will have a fixed cost of $60, and Processors have a fixed cost of $250. The totalprofit is Revenue - Cost.Objective: Determine how many Capacitors, resisters, and processors to use in order to maximize profit. Youwill also need to capture if you choose to use Capacitors (SC), Resistors (SR), and Processors (SP). (NOTE: Theprofit is made up of 6 numbers: First three for Revenue and last three for cost, thus why they are negative)Also, note SC, SR, SP are 1 or 0, so you will need to add a constraint in the solver for "BIN" instead of > or Lastly, you will need three constraints that show if SC, SR, or SP are 0, then the Available for Capacitor, Resistor,and Processors, is 0le:ConstraintCapacitor159160Notice that the last column of 160 should be the 160* SC. Therefore if we don't use SC and it is zero, then theavailable will be 0 instead of 160.ParameterCapacitor Resister ProcessorsAvailableTelevisions46102,300Computers101244,200Microwaves5632,200Available160210Profit2-2503-50ModelCapacitor Resister159194Profit17905025Processors50SC1-60SR1SP1

Prepare a spreadsheet as shown below

Answered: Lastly, you will need three constraints…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter11: Simulation Models

Section: Chapter Questions

Problem 47P

See similar textbooks

Similar questions

Boston Company use a special part in manufacturing of its finished products. The unit cost thisspecial part is $ 35, and details of its manufacturing cost is as follows. The $35 unit productcost of this part is based on average 25,000 number of parts produced each year.An outside supplier has offered to supply the 25,000 parts at a cost of $30 per part. The specialequipment used to manufacture the above part. This equipment can only be used formanufacturing of this part and if not used it has no resale value.The total amount of general factory overhead, which is allocated based on direct labor-hours,would be unaffected by this decision because it is fixed cost..Suggest the management whether to stop producing internally and buy them from theoutside supplier?Description CAD Direct Materials 10Direct Labor 6Variable overheads…
Bernie’s Bike Shop receives the following trade discounts: 20/15/15. The vendor’s price list indicates that 20 percent off list price is for purchasing bikes in quantities of 100 or more, 15 percent off list price is for assembling the bikes for customers, and 15 percent is for sales promotion and local advertising. If the manufacturer’s list price is $550, what should Bernie pay for each bike if he orders 110 bikes at a time, assembles the bikes, and displays and advertises them?
A carpenter makes some chairs for his business. The cushion of the chair costs $15 and the wooden structure costs $6.40. It takes 1.4 minutes to assemble the chair and the hourly cost is $90.00 for assembly time. The company has a fixed operating cost of $20000 per month. They sell the chairs for four times their total variable cost. The company wants to make a monthly profit of $5000. How many chairs must they sell?
A manufacturer has a production facility that requires 15,604 units of component JY21 per year. Following a long-term contract, the manufacturer purchases component JY21 from a supplier with a lead time of 7 days. The unit purchase cost is $25.6 per unit. The cost to place and process an order from the supplier is $121 per order. The unit inventory carrying cost per year is 10.5 percent of the unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is appropriate. If the manufacturer uses a constant order quantity of 2,640 units per order, what is the annual holding cost? Use at least 4 decimal places.
Your firm uses a periodic review system for all SKUs classified, using ABC analysis, as B or C items. Further, it uses a continuous review system for all SKUs classified as A items. The demand for a specific SKU, currently classified as an A item, has been dropping. You have been asked to evaluate the impact of moving the item from continuous review to periodic review. Assume your firm operates 52 weeks per year; the item’s current characteristics are:Demand 1D2 = 15,080 units/yearOrdering cost 1S2 = $125.00/orderHolding cost 1H2 = $3.00/unit/yearLead time 1L2 = 5 weeksCycle@service level = 95 percentDemand is normally distributed, with a standard deviation of weekly demand of 64 units.a. Calculate the item’s EOQ.b. Use the EOQ to define the parameters of an appropriate continuous review and periodic review system for this item.c. Which system requires more safety stock and by how much?
In the following scenario, what will your stockout costs be if you have 200 hammers in stock and you have orders of 80, 60, 50, 30, 120 You are a wholesaler selling hammers. You have a carrying cost for each hammer left in inventory of $.30 per unit, ordering cost of $60 per order placed, and a stockout cost of $30 per customer who is not fully satisfied and $3 per hammer for any orders not fulfilled (lost sales). Orders placed arrive in the sixth week after the week in which the order is placed. Smallest orders are filled first. $480 $1,080 $660 $450 $300
You are the manager of a retail store that sells home theater systems among other products. The weekly demand for these systems is 600. The warehouse you rent to store the inventory of home security systems charges you $8 per month for holding each unit of inventory. You buy these systems from a very reliable supplier for $250 per piece and sell each for $500 per piece. Each time you place an order to buy the systems from your supplier, you pay $416 as a fixed fee per order regardless of the quantity. Once the order is placed, the supplier takes exactly 1 week to deliver the order regardless of the quantity ordered. Please use this information to answer the following questions: a) What is the optimal order quantity (i.e. Economic Order Quantity OR EOQ - i.e. what quantity should be ordered per order) that would minimize the total annual ordering and holding costs? b) What is the ideal reorder level assuming no safety stock (i.e. the inventory level at which you should place the…
You are the manager of a retail store that sells home theater systems among other products. The weekly demand for these systems is 600. The warehouse you rent to store the inventory of home security systems charges you $8 per month for holding each unit of inventory. You buy these systems from a very reliable supplier for $250 per piece and sell each for $500 per piece. Each time you place an order to buy the systems from your supplier, you pay $416 as a fixed fee per order regardless of the quantity. Once the order is placed, the supplier takes exactly 1 week to deliver the order regardless of the quantity ordered. Please use this information to answer the following questions: a) What is the optimal order quantity (i.e. Economic Order Quantity OR EOQ - i.e. what quantity should be ordered per order) that would minimize the total annual ordering and holding costs? b) What is the ideal reorder level assuming no safety stock (i.e. the inventory level at which you should place the…
As a potential owner of a club known as Club Salida, you are interested in determining the necessary volume of sales in dollars to reach the breakeven next year. You decided to break down the club's sales into. four categories, where beer is the first. Your estimate of the sale of beer is that it will serve 30,000 servings. The selling price per unit will average $ 1.50; its cost is $ .75. The second category is food, of which you expect sell 10,000 units with an average unit price of $ 10.00 and a cost of $ 5.00. The third category is desserts and wine, of which you also hope to sell 10,000 units, but with an average unit price of $ 2.50 and a cost of $ 1.00. The last category is inexpensive lunches and sandwiches, of which you expect sell a total of 20,000 units with an average price of $ 6.75 and a cost per unit of $ 3.25. Your fixed costs (i.e. rent, utilities, etc.) are $ 1,800 a month plus $ 2,000 a month for entertainment. a) What is your breakeven point in dollars per month? b)…
The number of taxicabs in Motorville and the taxicab fares are regulated. The fare currently charged is Rs.500 a ride. Motorville taxicab drivers want to obtain government's permission to raise the fare to increase their revenues and ask you to be their economic adviser. After studying the market, you come up with the following demand schedule for taxicab rides: Price (Rupees per ride) Quantity demanded (rides per month) 300 160 400 120 500 80 600 40 700 0 (i) Calculate the price elasticity of demand for taxicab rides as the fare rises from Rs.500 to Rs.600. Is the demand…
A chocolate maker has annual demand of 250,000 pounds per year. It costs $1.25 to store a pound of chocolate for a year, and $350 to produce a batch. Use the economic lot size 3. formula to find the number of batches to be produced annually. Round to the nearest whole number of batches.
The Frist Corporation has the followinginternal controls related to inventory:1. Only authorized inventory warehousing personnel are allowed in inventory storageareas.2. All inventory products are stored in warehousing areas that are segregated fromother storage areas used to house equipment and supplies.3. All inventory held on consignment at Frist Corporation is stored in a separatearea of the warehouse.4. The inventory purchasing system only allows purchases from pre-approved vendors.5. The perpetual inventory system tracks the average number of days each inventoryproduct number has been in the warehouse.6. Microchips are embedded in each product and when inventory items are removedfrom the warehouse to shipping, radio-frequencies signal a deduction of inventoryto the perpetual inventory system.7. On a weekly basis, inventory accounting personnel take samples of inventoryproducts selected from the perpetual inventory system and verify that the inventoryis on-hand in the warehouse…

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