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

Discretionary Fiscal Policy Effectiveness, Discretionary fiscal policy will...

Discretionary fiscal policy will stabilize the economy most when: A.) deficits are incurred during recessions and surpluses during inflations B.) the budget is balanced each year C

Describe in detail about exchange rate systems, Describe in detail about Ex...

Describe in detail about Exchange rate systems Various countries have different exchange rate systems. The most significant characteristic of an exchange rate system is to what

Effect which have the bond market, Firms such a Moody's and Standard & Poor...

Firms such a Moody's and Standard & Poor's study corporations that issue bonds. They publish "ratings" for the bonds- evaluation of the likelihood of default. Suppose these rating

Aggregate demand and aggregate supply model, In the late 1990s, a growing n...

In the late 1990s, a growing number of economists expressed concern that the world policy makers were often focusing too much on fighting inflation, without fully taking into accou

Ashly''s budget constraint, Ashley can join a club for an annual fee of $20...

Ashley can join a club for an annual fee of $20. if she can purchase golf balls at 40% off the retail price. Draw ashly's budget constraint if she joins and if she does not join th

Find the break-even point, The Widget Manufacturing Company must replace a ...

The Widget Manufacturing Company must replace a widget machine, and is evaluating the capabilities of two systems. A requirement of management is that the machine chosen must be p

Component of balance payments, Component of balance payment: BOP is a ...

Component of balance payment: BOP is a statement  that summarises all the economic transactions between residents (individuals, companies and other organisations) of the home

Uncontrollable environmental variables, Consider an international firm you ...

Consider an international firm you are familiar with and what the firm needs to be concerned with when entering a foreign market. Specifically, in terms of the chapters you covered

What are the contents in the market strikes back, What are the contents in ...

What are the contents in the market strikes back? a. Price controls • Price ceiling • Price floor b. Quantity controls quota c. Excise tax d. Inefficiency

Granger causality, With the aim of this project to observe the impact of oi...

With the aim of this project to observe the impact of oil price shocks on macroeconomic indicators, testing for causality between these variables will establish whether or not, oil

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