Geraldine Shawhan is president of Shawhan File Works, a firm that manufactures two types of metal...
Geraldine Shawhan is president of Shawhan File Works, a firm that manufactures two types of metal file cabinets. The demand for her two-drawer model is up to 600 cabinets per week; the demand for a three-drawer cabinet is limited to 400 per week. Shawhan File Works has a weekly operating capacity of 1,300 hours, with the two-drawer cabinet taking 1 hour to produce and the three-drawer cabinet requiring 2 hours. Each two-drawer model sold yields a $10 profit, and the profit for the large model is $15. Shawhan has listed the following goals in order of importance:
Attain a profit as close to $11,000 as possible each week.
Avoid underutilization of the firm’s production capacity.
Sell as many two- and three-drawer cabinets as the demand indicates.
Please illustrate this problem in Excel
Homework Answers
We will solve linear programming model using Excel -> Solver as shown below.
Optimal solution is to produce 600 units of 2-drawer cabinets and 350 units of 3-drawer cabinets.
Total profit to be around $11250.
Please give thumbs up if you like my answer. Thank
you!
Add Answer to:
Geraldine Shawhan is president of Shawhan File Works, a firm
that manufactures two types of metal...
Geraldine Shawhan is president of Shawhan File Works, a firm that manufactures two types of metal...
Geraldine Shawhan is president of Shawhan File Works, a firm that manufactures two types of metal file cabinets. The demand for her two-drawer model is up to 600 cabinets per week; the demand for a three-drawer cabinet is limited to 400 per week. Shawhan File Works has a weekly operating capacity of 1,300 hours, with the two-drawer cabinet taking 1 hour to produce and the three-drawer cabinet requiring 2 hours. Each two-drawer model sold yields a $10 profit, and the...
In the furniture store that sells tables and chairs, business is good and so the demand...
In the furniture store that sells tables and chairs, business is good and so the demand for tables is up to 500 pieces per week and for chairs up to 300 pieces. The production has a weekly capacity of 1200 hours, with a table taking 40 minutes to produce and a chair 80 minutes. Each table nets a profit of $7/piece but a chair’s profit is now $10. The manager’s goals are to attain a profit of $10,000; to avoid...
1) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a...
1) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table below contains all relevant information concerning production capacities for each operation per day, along with net revenue per unit produced. The firm has a contract with an Indiana distributor to produce a minimum of 300 of each cabinet per week (or 60 cabinets per day). Owner Bob...
(Production problem) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and...
(Production problem) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table below contains all relevant information concerning production times per cabinet produced and production capacities for each operation per day, along with net revenue per unit produced. The firm has a contract with an Indiana distributor to produce a minimum of 300 of each cabinet per week...
Maxey & Sons manufactures two types of storage cabinets—Type A and Type B—and applies manufacturing overhead...
Maxey & Sons manufactures two types of storage cabinets—Type A and Type B—and applies manufacturing overhead to all units at the rate of $104 per machine hour. Production information follows. Type A Type B Anticipated volume (units) 20,800 39,000 Direct-material cost per unit $ 20 $ 30 Direct-labor cost per unit 25 25 The controller, who is studying the use of activity-based costing, has determined that the firm’s overhead can be identified with three activities: manufacturing setups, machine processing, and...
Maxey & Sons manufactures two types of storage cabinets—Type A and Type B—and applies manufacturing overhead...
Maxey & Sons manufactures two types of storage cabinets—Type A and Type B—and applies manufacturing overhead to all units at the rate of $160 per machine hour. Production information follows. Type A Type B Anticipated volume (units) 32,000 60,000 Direct-material cost per unit $ 48 $ 72 Direct-labor cost per unit 53 53 The controller, who is studying the use of activity-based costing, has determined that the firm’s overhead can be identified with three activities: manufacturing setups, machine processing, and...
please show all steps clearly 1. A company manufactures three types of items: A, B, and...
please show all steps
clearly
1. A company manufactures three types of items: A, B, and C. Each type of item produced incurs a variable cost and a raw material cost. Table 1 gives associated costs together with the selling price of each product. There are two types of resources (labor) used for producing each item, namely machinery time and craftsman time (Table 2). Each week, the company can obtain all the needed raw material but only 140 craftsman hours...
I need the answer to include solver and excel. Thank you. A Company produces two products....
I need the answer to include solver and excel. Thank
you.
A Company produces two products. Relevant information for each product is shown in the Table below. The company has a goal of $48 in profits and incurs $1 penalty for each dollar it falls short of this goal. A total of 32 hours of labor are available. A $2 penalty is incurred for each hour of overtime (labor over 32 hours) used, and $1 penalty is incurred for each...
Use the scenario given below to answer the following question(s) Ray Inc. manufactures two types of...
Use the scenario given below to answer the following question(s) Ray Inc. manufactures two types of gaming consoles, the sp2 hybrid and the sp3 hybrid models. The manufacturing process consists of two principal departments: design and production. The design department has 58 skilled workers, each of whom works 7 hours per day. The production department has 25 workers, who also work a 7-hour shift. On an average, to produce a sp2 hybrid, Ray Inc. requires 3.5 labor hours for design...
Rocket Computers is a local computer hardware company. They specialize in ordering computer components from manufacturers...
Rocket Computers is a local computer hardware company. They specialize in ordering computer components from manufacturers and assembling the components into a computer that can be sold in stores. They currently have two products on the market and the relevant information for each product is given in the table below. Rocket Computers has a goal of achieving $4800 in profits and incurs a $10 penalty for each dollar it falls short of this goal. The company has 32 hours of...
1) Winkler Furniture manufactures two different types of china cabinets: a French Provincial model and a Danish Modern model. Each cabinet produced must go through three departments: carpentry, painting, and finishing. The table below contains all relevant information concerning production capacities for each operation per day, along with net revenue per unit produced. The firm has a contract with an Indiana distributor to produce a minimum of 300 of each cabinet per week (or 60 cabinets per day). Owner Bob...
please show all steps
clearly
1. A company manufactures three types of items: A, B, and C. Each type of item produced incurs a variable cost and a raw material cost. Table 1 gives associated costs together with the selling price of each product. There are two types of resources (labor) used for producing each item, namely machinery time and craftsman time (Table 2). Each week, the company can obtain all the needed raw material but only 140 craftsman hours...
I need the answer to include solver and excel. Thank
you.
A Company produces two products. Relevant information for each product is shown in the Table below. The company has a goal of $48 in profits and incurs $1 penalty for each dollar it falls short of this goal. A total of 32 hours of labor are available. A $2 penalty is incurred for each hour of overtime (labor over 32 hours) used, and $1 penalty is incurred for each...
Use the scenario given below to answer the following question(s) Ray Inc. manufactures two types of gaming consoles, the sp2 hybrid and the sp3 hybrid models. The manufacturing process consists of two principal departments: design and production. The design department has 58 skilled workers, each of whom works 7 hours per day. The production department has 25 workers, who also work a 7-hour shift. On an average, to produce a sp2 hybrid, Ray Inc. requires 3.5 labor hours for design...
Rocket Computers is a local computer hardware company. They specialize in ordering computer components from manufacturers and assembling the components into a computer that can be sold in stores. They currently have two products on the market and the relevant information for each product is given in the table below. Rocket Computers has a goal of achieving $4800 in profits and incurs a $10 penalty for each dollar it falls short of this goal. The company has 32 hours of...
Most questions answered within 3 hours.
-
Red light of wavelength 675 nm is incident on a slit of width
4.56 × 10−6...
asked 7 minutes ago -
An object 4.0 mm high is on the optical axis of two lenses with
focal lengths...
asked 3 minutes ago -
Suppose that each team in a league has a demand curve for
generic advertising (a league-wide...
asked 3 minutes ago -
1. The WJC purchases denim. The avg. daily demand of
western is 1000 yards and the...
asked 12 minutes ago -
Memory Allocation
a) Is it possible to have both internal and external
fragmentation with fixed partition...
asked 12 minutes ago -
Steven can afford car payments of $300 a month for 72 months.
The bank will lend...
asked 29 minutes ago -
Embedded
System..
1.
Analyze
the instruction
sets below.
LDR R1, [R0,
#0x08]
SUB R1, R1,
R2,...
asked 33 minutes ago -
Use proper sentence structure to communicate clearly.
Choose the correct sentence structure in each of the...
asked 33 minutes ago -
There are investors who claim they only invest in companies with
great products and outstanding management,...
asked 36 minutes ago -
what is employee/ employer relations ?
why is Employee/ Employer relation is important in the context...
asked 54 minutes ago -
Explain the relationship between tests of acquisition and
payment cycle and tests of accounts payable. Give...
asked 52 minutes ago -
A hot-air balloon is descending with a velocity of (−2.00m/s)y^.
A champagne bottle is opened to...
asked 1 hour ago