Determine daily net revenue

Reference no: EM1350387

Stanley Furniture produces two types of china cabinets, First Provincial (FP) and Deluxe Modern (DM). Each cabinet goes through 3 departments: carpentry, painting and finishing. The following table contains relevant information on production times per cabinet produced, daily production capacities for each department and net revenue per cabinet produced. Woodstock has a contract with its distributor to supply at least 60 units of each type of cabinet per day. The company would like to determine a product mix to maximize daily net revenue.

Department

Carpentry Painting Finishing Net Revenue
hrs/cabinet hrs./cabinet hrs./cabinet

s /cabinet
Cabinet type
FP 3 1.5 0.75 28
DM 2 1 0.75 25
Dept. capacity (hrs.) 360 200 125

Using Excel and the Excel Solver:

(a) What product mix maximizes daily net revenue, and what is daily net revenue?

(b) Stanley Furniture can purchase 30 additional hours of carpentry time for $20 per hour. Should the company purchase the additional time? Explain.

Reference no: EM1350387

Questions Cloud

Create structurally sound relational database schema : Create a structurally sound relational database schema showing the minimum number of fields, tables, and relationships between the tables.

Need for and utilization of social support : How can these populations bridge the gap between the need for and utilization of social support?

Gaap and income tax accounting : Describe how they are similar and why there are differences. Also, include specific examples of how and when to apply the principles of both types of accounting.

Explain organizational stress prevention : Identify at least one organizational stress management method aligned with each type of prevention

Determine daily net revenue : Stanley Furniture produces two types of china cabinets, First Provincial and Deluxe Modern. Each cabinet goes through three departments: carpentry, painting and finishing.

With what force f2 should the second crewman pull : A car accelerates from rest to a kinetic energy of 1.65 x 10^5 Joules in a distance of 646 m. How much force did the car's engine deliver to produce the change in kinetic energy.

Underrepresentation of various cultural groups : Can someone help me with finding the problems that may be associated with underrepresentation of various cultural groups in research studies, and does it devalue the data collection?

Explain what are the pros and cons of north american tire''s : Explain What are the pros and cons of North American Tire's strategy of hiring replacement workers

Elucidate what is the best form of business organization : Elucidate what is the best form of business organization to select based on various considerations, including taxes, liability, capital contributions, sharing of profits adn losses, management and control, and survivorship

User Account

All Pages