Excel model spreadsheet by entering the required totals

Assignment Help Operation Management

Reference no: EM131721519

A company makes two products - product A and product B which are sold at a profit per unit of $60 and $100, respectively. The three resources used to make these products are summarized in the table below. Complete the excel model spreadsheet by entering the required totals calculations and use Solver to maximize the total profit. Use the results to answer the following questions. Product A Product B Total Resources Available Resource X 0 4 140 Resource Y 4 8 296 Resource Z 6 0 186

A. What is the total profit? ____________________

B. Product A number of units? ____________________

C. Product B number of units? ____________________

D. Resource X total? ____________________

Reference no: EM131721519

Questions Cloud

Describe the growth strategies : Which of the growth strategies discussed in the chapter are the most risky? Which are the least risky? What role should risk play in a company's decision.

Discuss big data into its data management : what recommendation would you give to Nordea Bank about incorporating Big Data into it's data management

What are the safety stock and reorder point : The daily demand of a product can be specified by a normal distribution. What are the safety stock and reorder point for a 95% service level?

What has changed after trumps selection : What has changed after Trump's selection? What Trump thinks about DACA? Does he want to provide education benefits for Daca students?

Excel model spreadsheet by entering the required totals : Complete the excel model spreadsheet by entering the required totals calculations and use Solver to maximize the total profit.

Discuss the key technical and governance issues : Identify and discuss the key technical and governance issues that both consumers and providers of cloud service need

What is the net income of the firm for the year : At the end of its third year of operations, the Best Manufacturing Co. had $4,500,000 in revenues; $3,375,000 in cost of goods sold; $450,000.

Case-using co-branding to reduce costs and boost sales : Have you ever stopped at a gas station and caught a quick lunch at an Arby's or a Blimpie sub sandwich inside? Or have you ever noticed that Baskin Robbins.

Negotiated price of the new car : You have just agreed on the final price for your new car and now you have to finance the purchase. The negotiated price of the new car

User Account

All Pages