Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A handcraft store specialising in making decorative and useful products from wood needs to decide on how many products should be made for the next

A handcraft store specialising in making decorative and useful products from wood needs to decide on how many products should be made for the next week. The store owner thinks that they will require at least 120 units of their popular wooden bottle. The store owner also thinks that their new product of wooden wall dcor would also attract high sales and expects to make at least 80 of them. Their production worker has provided information about the time required to make the products: The wooden bottle will require 30 minutes of carpentry and 8 minutes of painting time. Whereas, the wooden wall decor will require 25 minutes of carpentry and 10 minutes of painting. The store has decided to sell the wooden bottle for $5.00 a unit and to price the wooden wall decor at $6.00 for each unit. At this time, production workers can devote 120 hours to carpentry and 50 hours to painting. They charge the store S1 for handcrafting each of the items. How many of each product should the store make to maximise the profit what is the store's expected profit?

(Please mention clearly the objective function and the constraints below and solve using Excel Solver (preferred) and attach the Excel file with this file)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Strategic Management

Authors: J. Hunger, Thomas Wheelen

5th Edition

0136006698, 9788120348615

More Books

Students also viewed these General Management questions