Step 6: Profit or Loss

IPS operates a factory which produces the MiniY and the MiniX. During September 20X8, the factory produced 500 units of MiniY and 600 units of MiniX. The joint cost related to the operation was $3,000,000. MiniX sells for $3,500 per unit and MiniY sells for $3,800 per unit. Allocate the joint costs (production cost allocation) using the relative sales values of MiniY and MiniX. You hope you can prove that the MiniX is profitable, but you also recognize that numbers don't lie!

Question 6: With the costs that you calculate, what is the profit or loss associated with MiniX?

Before starting your calculations, review the materials on integrating accounting and financial information.

Submit your Profit or Loss Report and Calculations to the dropbox below. Be sure to show your calculations in Excel and provide a narrative analysis in PowerPoint. Your narrative analysis should summarize the results of your analysis and make recommendations for the benefit of the company.

Before you submit your assignment, review the competencies below, which your instructor will use to evaluate your work. A good practice would be to use each competency as a self-check to confirm you have incorporated all of them in your work.

3.1 Identify numerical or mathematical information that is relevant in a problem or situation.

3.2 Employ mathematical or statistical operations and data analysis techniques to arrive at a correct or optimal solution.

3.3 Analyze mathematical or statistical information, or the results of quantitative inquiry and manipulation of data.

3.4 Employ software applications and analytic tools to analyze, visualize, and present data to inform decision-making.

10.5 Develop operating forecasts and budgets and apply managerial accounting techniques to support strategic decisions.