Estimate the maximum possible daily profit, Macroeconomics

Assignment Help:

Shambles have selected the "Mythical Beasts" range and decided to concentrate on "Pegasus" and "Phoenix." They would now like to find the right mix of these two products in order to maximise profit. Each toy has to go through two processes during manufacture: sewing and stuffing.

Pegasus takes 30 minutes to sew whilst Phoenix takes 20 minutes; there are 10 hours (600 minutes) available for sewing each day.

Pegasus takes 20 minutes to stuff whilst Phoenix takes 25 minutes; there are 10 hours (600 minutes) available for stuffing each day.

Pegasus generates £4 profit per toy whilst Phoenix generates £5 profit per toy.

What is the maximum possible daily profit, and how many of each product should be produced in order to achieve this?

Use "Solver" in Microsoft Excel to solve this problem. Include:

a print-out of cell values
a print-out of cell formulae
a print-out of the Solver dialogue box with optimisation conditions and constraints
an Answer Report from Solve
a statement of the answer in words

 


Related Discussions:- Estimate the maximum possible daily profit

Summary of the cross model, Summary of the cross model The below list...

Summary of the cross model The below list summarizes the cross model and associates it to classical model:  Labor Market: Real wages W/P is exogenous in cross model

What are the potential disadvantages of growth, What are the potential disa...

What are the potential disadvantages of growth? The potential disadvantages of growth are as follows: • Raised pollution, • Depletion of non renewable natural resources

Unemployed individual decides to spend the day fishing, 1. An unemployed in...

1. An unemployed individual decides to spend the day fishing. The opportunity cost of fishing is equal to A) The cost of bait and any other monetary expenses. B) Zero, becaus

Trade cycle, discus the various measures that may be taken by a firm to cou...

discus the various measures that may be taken by a firm to counteract the evil effect of a trade cycle

Estimate the optimal level of provision, There are a lot of mosquitoes in ...

There are a lot of mosquitoes in the island of Liholiho. Only two people live in this island, Robinson Crusoe and Man Friday. Their respective demand curves for mosquito control ar

State about the United States government bonds, State about the unitesd sta...

State about the unitesd state government bonds In most countries, you find government bonds with longer maturity. For example, in the United States you have Treasury notes (two

Financial Crises, #question. BANK Z (@ 10% RR) ASS...

#question. BANK Z (@ 10% RR) ASSETS LIABILITIES RR: K200,000 Deposits : K2,000,000 ER : K1,800,000 You are given the above Balance sheet for Bank Z as

Reimbursement affect the number of admissions, How will each of the followi...

How will each of the following bases for hospital reimbursement affect the number of admissions, the average length of stay, the volume of services per day, and the unit cost of se

Trade between the two countries, Given the above trade between the two coun...

Given the above trade between the two countries, explain the trade effects on product prices, and factor incomes. Why do these effects occur?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd