For each question calculation should be on the excel sheet and their explaination on the PPT 3 ppt for each question

Suppose IPS uses markup pricing for Android01. Fixed costs are \$4.5 million, and for a level of production of 300 units, the variable cost-per-unit is \$48,000.

Question 3: What is the price of the Android01 at 30 percent markup over full cost?

Submit your Markup Pricing Report and Calculations Be sure to show your calculations in PowerPoint and in an Excel spreadsheet.  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.

Step 4: Choose the Profit-Maximizing Output Level

The CEO’s next question is, “What level of output would be required to maximize our profit on the Android01?” You have calculated the variable cost-per-unit for different levels of production. From market research, you have a schedule of prices for these levels. The information is summarized in the table below:

A recommendation on output could affect everyone in the company, from management to sales, to the floor manager and assembly line workers! You don’t want to get this one wrong so you take some extra time to proof your calculations.

Question 4: Based on the profit-maximization analysis, what level of output should you recommend to the CEO?

Before starting your calculations, review materials on profit maximization output.

Submit your Profit-Maximization Output Report and Calculations. 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.

Step 5: Budget

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

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 May 20X8 stating the total cost. Use a spreadsheet to display your data and calculations.

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

Submit your Production Cost Budget Report and Calculations  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.