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

Aggregate Demand, According to liquidity preference theory, an increase in ...

According to liquidity preference theory, an increase in the price level causes the interest rate to: a.decrease, which decreases the quantity of goods and services demanded. b.inc

National income, Y= C+I+G C= 100,000000+ 0.4yd I= 400,00000 T= 0.2+60m G= ...

Y= C+I+G C= 100,000000+ 0.4yd I= 400,00000 T= 0.2+60m G= 750, 000000 Calculate equilibrium level of income

Stock trading company, An online stock trading company makes part of their ...

An online stock trading company makes part of their revenue from clients when the clients trade stocks therefore, it is important to the company to have an good idea of how many tr

Market index for small cap stocks, The Russell 2000 is a market index for s...

The Russell 2000 is a market index for small cap stocks - What do these changes in P/E ratios over last year tell you about current valuation in small caps and the different market

Expected value of demand for paint, Each Home Depot store must decide how m...

Each Home Depot store must decide how much paint to order each month. From historical records, they know that the amount of paint they sell during May is distributed as follows: th

What is store of value - economic functions of money, Store of value - Econ...

Store of value - Economic functions of money If you are a fisherman and have a temporary surplus of fish that you want to store for the future, storing the fish might not b

Quality of health care, Explain how changes in the quality of health care w...

Explain how changes in the quality of health care will influence the demand for care.

Credit multiplier, use a numerical example to illustrate how credit multipl...

use a numerical example to illustrate how credit multiplier works

Credit multiplier, how can the central bank influence the size of the multi...

how can the central bank influence the size of the multiplier

Oil revenue on agricultural productivity, please,how do i relate keynesian ...

please,how do i relate keynesian theories on fiscal policy to the topic"impact of oil revenue on agricultural productivity?

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