Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started