there is extra information, please help ASAP!

operations research!

The Case Report is to be completed as a report to management. You should complete the analysis as requested in the assignment, but the analysis should be reported to me in the form of a business report. Case reports should be in the format of a report to management. Please refer to "How to write a business report" under content on D2L for guidelines for how a typical business report is written. Part 2 of "How to write a business report" includes a structure for your report. While I expect your report to have titled sections, I prefer that your report use different sections. My preferred section titles are given below. In addition, you do not need to include a covering letter/memorandum, executive summary, table of contents, or references. The report is likely to be relatively short, probably no more than 2 or three pages. In your report, I suggest you include the following sections. 1. Introduction: The introduction sets the stage for the reader. It gives the context for the report and generates the reader's interest. It orients the reader to the purpose of the report and gives them a clear indication of what they can expect. Explain the task that you have been given and what you plan to do to address the problem at hand. indication of what they can expect. Explain the task that you have been given and what you plan to do to address the problem at hand. 2. Conclusions/recommendations What did you find? The assignment asks for specific recommendations, make them here but also include any other recommendations you think are important. Refer to "How to write a business report" for more guidelines. 3. Findings and discussion This is the main part of the report. You should report all of your methods and findings. Include a discussion of the method you used, and what results you discovered. a. Modeling Method Explain the analytical methods that you used and why that method is appropriate for the task you have been given. Explanations should be at an intuitive level, and not dependent on "jargon" to explain methods. b. Findings (or Results) You must also report your findings or results. Pay particular attention to the items in the assignment memo. I will expect each of them to be included in your report. Be sure to answer all three questions posed in the assignment. But again, offer any additional information you think is important. Make sure to be clear when explaining what you found. Use tables if they help you communicate points to the reader. In many ways this is the most important section in the report. Make sure it is clear what you found. 4. Appendix All detailed calculations should be in an appendix to the report. That is, include your spreadsheet with your work in an appendix. Make sure they are well organized and readable. Make sure all elements of your spreadsheets are labeled appropriately. Try to keep each spreadsheet on a single page, but if you cannot, then make sure to label the columns/rows that are continued on additional pages. recently designed two universal weight machines for the home exercise market. Both machines use B patented technology that provides the user with an extremely wide range of motion for each type of exercise. At a recent trade show, demonstrations resulted in significant dealer interest. The two machines, which BFI named the BodyPlus100 (BP100) and the BodyPlus200 (BP200), require different amounts of resources to produce. The BP100 consists of a frame, a press station, and a pec-dec station. Each frame requires 4 hours of machining and welding time and 2 hours of painting and finishing time. Each press station requires 2 hours of machining and welding and 1 hour of painting and finishing time. Each pec-dec station requires 2 hours of machining and welding and 2 hours of painting and finishing time. The BP100 also requires 2 hours of assembly, testing, and packaging. The part costs for the BP100 are $450 for a frame, $300 for each press station, and $250 for each pec-dec. Packaging costs are $50 per unit. The BP200 consists of a frame, a press station, a pec-dec station, and a leg-press station. Each frame requires 5 hours of machining and welding time and 4 hours of painting and finishing time. Each press station requires 3 hours of machining and welding and 2 hours of painting and finishing time. Each pecdec station requires 2 hours of machining and welding and 2 hours of painting and finishing time. The BP200 also requires 2 hours of assembly, testing, and packaging. The part costs for the BP 200 are $650 for a frame, $400 for each press station, and $250 for each pec-dec station requires 3 hours of machining and welding and 2 hours of painting and finishing time. dec station requires 2 hours of machining and welding and 2 hours of painting and finishing time. The BP200 also requires 2 hours of assembly, testing, and packaging. The part costs for the BP200 are $650 for a frame, $400 for each press station, and $250 for each pec-dec station, and $200 for each leg-press station. Packaging costs are $75 per unit. For the next production period, management estimates that 600 hours of machining and packaging time will be available, 450 hours of painting and finishing time and 132 hours of assembly, testing, and packaging time. Current labor costs are $20 per hour for machining and welding time; $15 per hour for painting and finishing time; and $12 per hour for assembly, testing, and packaging time. The market suggests the BP100 can be sold for a retail price of $2400 and the BP200 can be sold for $3500. BFI sells to authorized dealers at 70% of retail price. BFI's president believes that the unique capabilities of the BP200 can help position BFI as one of the leaders in the high-end exercise equipment. Consequently, she states that the number of units of the BP200 produced must be at least 25% of the total production of machines. The table below summarizes the revenue and cost information from above. Revenue and Cost Flements for the BP100 and BP200 Analyze the production problem for BFI Inc. and prepare a report for BFI's president presenting your findings and recommendations. Include (but do not limit your discussion to) a consideration of the following items. Managerial Report Analyze the production problem for BFI Inc. and prepare a report for BFI's president presenting your findings and recommendations. Include (but do not limit your discussion to) a consideration of the following items. 1. What is the profit per unit for each BP100 and BP200 ? 2. What is the recommended number of BP100 and BP200 machines BFI should produce in order to maximize profit? 3. Would it be worthwhile to hire an additional worker to do machining and welding if that worker could devote 10 hours to production of BP100 and BP2D0? Include a copy of the mathematical formulation of this linear programming model along with a copy of your Excel spreadsheet setup with solution in an appendix to your report