Should they implement the ai program

Assignment Help Finance Basics

Reference no: EM133616071

Problem

One Word Document with a report outlining your recommendations for the issues listed in the case. The document should also include an appendix for each of the issues showing your algebraic equations and decisions, and a readable screen clip of your Excel output, including the Solver dialogue box (see parts a & b below). This is especially important to show how you used solver.

One Excel Spreadsheet with clearly labeled worksheets (one worksheet for each of the issues in the assignment). The work in the worksheets needs to be well organized and clearly labeled, with formulas used appropriately. Examples of potential formats can be found in the course materials for linear programming

Penny Chairs received financing from Funance Inc. to produce three types of outdoor chairs that are ideally suited to the beach, pool, and patios: sling chairs, Adirondack chairs, and hammocks. At its Bruderheim factory, the unit profit for these chairs is $40, $100, and $90 respectively. Additionally, each type of chair requires cutting, assembly, and finishing. Workers are available to produce these chairs have 120 hours available per month however they cannot spend more than 50 hours per month on any one activity (i.e. cutting, assembly, and finishing). Sling chairs are made up of ten wood pieces for the frame and one piece of cloth. The cutting of the wood takes 30 minutes. Assembling includes sewing the cloth and the attachment of rivets, screws, and fabric. This takes 45 minutes per chair. The finishing step involves sanding, staining, and varnishing chair parts and takes one hour per chair. Adirondack chairs take two hours for the cutting phase as well as the assembly phase whereas the finishing stage takes one hour. For a hammock, cutting takes 0.4 hours, assembly takes three hours, and finishing takes one hour.

I. Penny Chairs wants to determine how much of each chair they should produce at their Bruderheim factory to maximize profit.

II. Penny Chairs has utilized AI to reduce all the above times by 10% but the AI program license will cost $300 per month. Should they implement the AI program?

Reference no: EM133616071

Questions Cloud

What might be the cause of the acute shortness of breath : What might be the cause of the acute shortness of breath? What underlying pathophysiology is likely responsible for the problem

Discuss the contributions of that theory to nursing practice : Identify the concepts and relational statements of the selected nursing theory. Discuss the contributions of that theory to nursing practice

Was inoculation theory used for an intervention or campaign : Was inoculation theory used for an intervention or campaign? What was the outcome from the study that used this theory

Recognize this as possible signs and symptoms of : notice a patient has had a RAPID change in cognition, is restless, and has started to experience hallucinations. You recognize this as possible signs

Should they implement the ai program : Penny Chairs wants to determine how much of each chair they should produce at their Bruderheim factory to maximize profit. Should they implement the AI program?

What are the major forms of reimbursement on the delivery : What are the major forms of reimbursement on the delivery of health care services for the organization?

Identify the breakeven stock prices at expiration : Hold until the options expire. Determine the profits and graph the results. Identify the breakeven stock prices at expiration and the minimum profit.

What should be the current price of a share of stock : What should be the current price of a share of stock if a $5 dividend was just paid; stock has a required return of 20% and constant dividend growth rate of 6%?

How did you promote the image of nursing : How did YOU promote the image of nursing by modeling values and articulating the knowledge, skills, and attitudes of the nursing profession?

User Account

All Pages