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

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

What is money and what is not money, Q. What is money and what is not money...

Q. What is money and what is not money? If you are trying to conclude if something is money, basically consider whether it would be accepted in most stores as payment. Then you

Aggregate demand and supply diagram, Using an aggregate demand and supply d...

Using an aggregate demand and supply diagram, explain how each of the following scenarios affects the equilibrium price level and aggregate output. Consider first the short-run, th

Classical model, using a graph of the classical labour market,illustrate th...

using a graph of the classical labour market,illustrate the effects of a real wage existing in the market that is lower than the equilibrium real wage.What will eventually happen i

To make a product workers concentrate on specialized tasks, The system wher...

The system where workers concentrate on specialized tasks to make a product is referred to as: A. Coincedence of wants B. Roundabout production C.Freedom of enterprise

# spending multiplier, Economist mark Edward the multiplier effect of Alask...

Economist mark Edward the multiplier effect of Alaska trade to Japan another 600 million is added to the state economy for Japanese recovery, associated press and local wire June 2

The circular flow of income in a closed economy, The circular flow of incom...

The circular flow of income in a closed economy   A closed economy exists when there is no international trade. We shall also assume that in this particular closed economy there

Price-elasticity of demand coefficient of a firm''s product, a) Use the arc...

a) Use the arc-approximation formula to calculate the price-elasticity of demand coefficient of a firm's product demand between the (quantity, price) points of (100, $20) and (300,

Online homework, I want you to do online homework about The Influence of M...

I want you to do online homework about The Influence of Monetary and Fiscal Policy on Aggregate Demand All the questions around 10

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