Question

Submit your Profit-Maximization Output Report and Calculations to the dropbox below. Submit a spreadsheet showing your...

Submit your Profit-Maximization Output Report and Calculations to the dropbox below. Submit a spreadsheet showing your calculations in Excel and provide a narrative analysis in Word. Your narrative analysis should summarize the results of your analysis and make recommendations for the benefit of the company.

Your CEO has also asked you to prepare a production cost budget for the MiniY for May 20X8. The actual costs in April 20X8 were as follows:

MiniY: Production Cost Budget
April 20X8
Production–Units of MiniY 3,000
Components cost (variable) 24,000,000
Labor cost (variable) 13,500,000
Rent (fixed) 6,000,000
Depreciation (fixed) 6,000,000
Other (fixed) 2,000,000
Total $51,500,000

For the month of May, the number of MiniY produced will increase to 3,200, reflecting an anticipated sales increase related to a new marketing campaign.

Question 5: Using the above information, prepare a budget for MiniY for May 20X8, stating the total cost. Use a spreadsheet to display your data and calculations.

IPS operates a factory, which produces the MiniY and the MiniX. During September 20X8, the factory produced 3200 units of MiniY and 3000 units of MiniX. The joint cost related to the operation was $3,000,000. MiniX sells for $27,100 per unit and MiniY sells for $25,000 per unit. Allocate the joint costs using the relative sales values of MiniY and MiniX.

Question 6: With the costs that you calculate, what is the profit or loss associated with MiniY? NOTE:Assume that the variable and fixed costs mentioned in Question 5 are also applicable to Question 6 when calculating the profit or loss for MiniY. The costs for this question will be the total of the cost calculated in the above MiniY: Production Cost Budget plus the share of costs of the $3,000,000 (from the paragraph above) allocated to MiniY.

Please ADD the fixed and Variable costs from question 5 thats in the chart above!

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Using an Excel spreadsheet, please complete the calculations for this cost-saving problem. Please then submit your...
Using an Excel spreadsheet, please complete the calculations for this cost-saving problem. Please then submit your Excel worksheet with your Exam. Assumptions: ABC, Inc. is considering investing in a packaging machine for its soup production facility. The estimated cost of this packaging machine is $110,000. The packaging machine is estimated to have a four-year useful life and will be depreciated using the straight-line method. No salvage value is expected at the end of the machine’s life on December 31, Year...
Match the term with the correct definition or explanation.    Cost-Volume-Profit (CVP) analysis    Break-even analysis...
Match the term with the correct definition or explanation.    Cost-Volume-Profit (CVP) analysis    Break-even analysis Relevant range Fixed costs Variable costs    Contribution margin    Contribution margin ratio Margin of Safety Absorption costing Variable costing Budgeting    Sales budget Production budget    Direct materials budget Cash budget Fixed budget Flexible budget Standard costs Standard overhead costs a. This method excludes fixed overhead costs from total product costs. b. A budget that is prepared based on several different amounts of...
Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units...
Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units to be produced: April 1,000 units May    1,200 units June    1,250 units Each unit requires 2 parts of component A and 3 parts of component B. Component A cost is $1.25 per unit and component B cost is $.80 per unit. Each unit requires the following labor: 2 hours in the processing department 1 hour in the assembly department Processing department labor rate is...
Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units...
Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units to be produced: April    1,000 units May     1,200 units June     1,250 units Each unit requires 2 parts of component A and 3 parts of component B. Component A cost is $1.25 per unit and component B cost is $.80 per unit. 1.Calculate the Direct Material budgeted cost for May 2018 2.Calculate the Direct Material budgeted cost for the quarter April - June 2018...
Patel and Sons, Inc., uses a standard cost system to apply overhead costs to units produced....
Patel and Sons, Inc., uses a standard cost system to apply overhead costs to units produced. Practical capacity for the plant is defined as 55,800 machine hours per year, which represents 27,900 units of output. Annual budgeted fixed overhead costs are $279,000 and the budgeted variable overhead cost rate is $3.90 per unit. Factory overhead costs are applied on the basis of standard machine hours allowed for units produced. Budgeted and actual output for the year was 21,700 units, which...
Profit Maximization for a Perfectly Competitive Firm Goal: To determine how much candy George’s company should...
Profit Maximization for a Perfectly Competitive Firm Goal: To determine how much candy George’s company should produce to make the maximum profit it can possibly make. What you must know in order to successfully complete this assignment: The definition of profit and how to calculate it. The definitions of Total Cost (TC), Total Variable Costs (TVC) Total Fixed Costs (TFC), and Marginal Costs (MC) and how to calculate them. The definitions of Total Revenue (TR) and Marginal Revenue (MR), how...
Flexible Budget for Selling and Administrative Expenses for a Service Company Morningside Technologies Inc. uses flexible...
Flexible Budget for Selling and Administrative Expenses for a Service Company Morningside Technologies Inc. uses flexible budgets that are based on the following data: Sales commissions 7% of sales Advertising expense 25% of sales Miscellaneous administrative expense $1,850 per month plus 3% of sales Office salaries expense $17,000 per month Customer support expenses $2,600 plus 4% of sales Research and development expense 5,750 per month Prepare a flexible selling and administrative expenses budget for April for sales volumes of $115,000,...
Patel and Sons, Inc., uses a standard cost system to apply overhead costs to units produced....
Patel and Sons, Inc., uses a standard cost system to apply overhead costs to units produced. Practical capacity for the plant is defined as 55,500 machine hours per year, which represents 27,750 units of output. Annual budgeted fixed overhead costs are $277,500 and the budgeted variable overhead cost rate is $3.80 per unit. Factory overhead costs are applied on the basis of standard machine hours allowed for units produced. Budgeted and actual output for the year was 21,600 units, which...
The manufacturing cost of Sunrise Industries for three months of the year are provided below: Total...
The manufacturing cost of Sunrise Industries for three months of the year are provided below: Total Cost Production April $ 63,000 900 units May 80,920 1,600 units         June 100,300 2,400 units                     Using the high-low method, determine the (a) variable cost per unit, and (b) the total fixed costs (c) what is the purpose of using the high-low method?         All work must be shown for credit    Please label your answers as (a), (b), and (c)
Blue, Inc., produces amplifiers. Each unit sells for $900. Below is information on production/sales and costs...
Blue, Inc., produces amplifiers. Each unit sells for $900. Below is information on production/sales and costs for 2016: Production and Sales in Units Production Costs Selling and Admin. Costs January 105 $88,900 $23,500 February 118 97,200 25,400 March 97 83,200 22,700 April 107 89,900 23,400 May 114 96,700 25,200 June 124 103,100 26,300 July 127 106,300 26,900 August 133 107,600 27,100 September 138 113,417 28,194 October 126 105,200 26,300 November 124 102,400 26,000 December 108 90,800 24,000 Total 1,421 $1,184,717...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT