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 equation which relates the equilibrium price, The inhabitants ...

The inhabitants of Fantasia live for two periods, 0 and 1. They consume a nonrenewable resource called Fantasium in each period. Fantasium has to be extracted from the ground and t

Macroeconomic policy issues facing the u.s. economy, While referring to the...

While referring to the "EYE on YOUR LIFE" section on, discuss the macroeconomic policy issues facing the U.S. economy today based on the economic concepts you have learned in this

Economics, The Neoclassical thinking that assumes that all firms are establ...

The Neoclassical thinking that assumes that all firms are established with the intention of making profit has been challenged by the managerial discretion models. How successful ha

What is labor market, Q. What is Labor Market? Labor market in the IS-L...

Q. What is Labor Market? Labor market in the IS-LM model is the same as in cross model. Hence the IS-LM model is only applicable if profit-maximizing quantity of L would result

What is treasury bills, What is Treasury bills In most countries you wi...

What is Treasury bills In most countries you will find many types of government bonds. An important distinction is the duration of the bond, that is, the difference between the

Assignment , I want you to solve problem in Macroeconomics.It is in the fil...

I want you to solve problem in Macroeconomics.It is in the file attachment.

Evaluate nominal wages, Q. Evaluate Nominal wages? Nominal wages ...

Q. Evaluate Nominal wages? Nominal wages W = (W/P).P The nominal wage is equal to the real wage times the price level. Because the real wag

Banking system, how is credit creation by commercial bank

how is credit creation by commercial bank

Explain why quantitative measures, Suppose a company is considering two inv...

Suppose a company is considering two investment projects. Both projects require an upfront expenditure of $30 million. The company estimates that the cost of capital is 10% and tha

List of major emerging-market economies, List of major emerging-market econ...

List of major emerging-market economies To determine if the UK is to benefit from growth of emerging-market economies in the future, it should start exporting goods and specif

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