show all calculations please. On these Excel sheets, you will need to prepare a complete projected income statement in the contribution format for each scenario, in the manner of a flexible budget.The cells will be checked for appropriate formulas, when appropriate. Please highlight the specific answer to the question being posed.Carolina Manufacturing Company has been operating at a loss for several years. A management team has assembled to determine what course of action to takenext year to reach profitability. They begin by reviewing the most recent income statement (below).Sales (45,000 units at $15)Less cost of goods sold:Gross marginLess operating expensesNet lossDirect materialsDirect laborManufacturing overheadCarolina Manufacturing CompanyIncome StatementFor the Year Ended December 31Selling expensesVariableSales commissiShippingFixed (advertisiAdministrative expensesVariable (billingFixed (salaries135,000117,450147,75040,5008,100180,0002,70022.000$675,000400,200274,800228,60074.700($28,500)All variable expenses vary with the number of units sold, except for sales commissions, which are based on a percentage of sales dollars. Variable manufacturingoverhead is forty-five cents per unit. The plant has a capacity of 75,000 units per year.In order to facilitate the work of the management team, you are asked to prepare various spreadsheets and specific computations in Excel.A) Reformat the income statement in the contribution format. Include both a Total column and Per Unit column in the statement.

Income Statement :— Income statement of the company provide the wealth of the Company. An income…

Net loss ($28,500) All variable expenses vary with the number of units sold, except for sales commissions, which are based on a percentage of sales dollars. Variable manufacturing overhead is forty-five cents per unit. The plant has a capacity of 75,000 units per year. In order to facilitate the work of the management team, you are asked to prepare various spreadsheets and specific computations in Excel. A) Reformat the income statement in the contribution format. Include both a Total column and Per Unit column in the statement.

Net loss ($28,500) All variable expenses vary with the number of units sold, except for sales commissions, which are based on a percentage of sales dollars. Variable manufacturing overhead is forty-five cents per unit. The plant has a capacity of 75,000 units per year. In order to facilitate the work of the management team, you are asked to prepare various spreadsheets and specific computations in Excel. A) Reformat the income statement in the contribution format. Include both a Total column and Per Unit column in the statement.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter10: Decentralization: Responsibility Accounting, Performance Evaluation, And Transfer Pricing

Section: Chapter Questions

Problem 1CE: Forchen, Inc., provided the following information for two of its divisions for last year: Required:...

See similar textbooks

Similar questions

Carmichael Corporation is in the process of preparing next years budget. The pro forma income statement for the current year is as follows: Required: 1. What is the break-even sales revenue (rounded to the nearest dollar) for Carmichael Corporation for the current year? 2. For the coming year, the management of Carmichael Corporation anticipates an 8 percent increase in variable costs and a 60,000 increase in fixed expenses. What is the break-even point in dollars for next year? (CMA adapted)
Review the completed master budget and answer the following questions: Is Ranger Industries expecting to earn a profit during the next quarter? If so, how much? Does the company need to borrow cash during the quarter? Can it make any repayments? Explain. (Carefully review rows 74 through 80.)
Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?
The Lockit Company manufactures door knobs for residential homes and apartments. Lockit is considering the use of simple (single-driver) and multiple regression analyses to forecast annual sales because previous forecasts have been inaccurate. The new sales forecast will be used to initiate the budgeting process and to identify more completely the underlying process that generates sales. Larry Husky, the controller of Lockit, has considered many possible independent variables and equations to predict sales and has narrowed his choices to four equations. Husky used annual observations from 20 prior years to estimate each of the four equations. Following are definitions of the variables used in the four equations and a statistical summary of these equations: St=ForecastedsalesindollarsforLockitinperiodtSt1=ActualsalesindollarsforLockitinperiodt1Gt=ForecastedU.S.grossdomesticproductinperiodtGt1=ActualU.S.grossdomesticproductinperiodt1Nt1=Lockitsnetincomeinperiodt1 Required: 1. Write Equations 2 and 4 in the form Y = a + bx. 2. If actual sales are 1,500,000 in the current year, what would be the forecasted sales for Lockit in the coming year? 3. Explain why Larry Husky might prefer Equation 3 to Equation 2. 4. Explain the advantages and disadvantages of using Equation 4 to forecast sales.
Iona Company, a large printing company, is in its fourth year of a five-year, quality improvement program. The program began in 20x0 with an internal study that revealed the quality costs being incurred. In that year, a five-year plan was developed to lower quality costs to 10 percent of sales by the end of 20x5. Sales and quality costs for each year are as follows: Budgeted figures. Quality costs by category are expressed as a percentage of sales as follows: The detail of the 20x5 budget for quality costs is also provided. All prevention costs are fixed; all other quality costs are variable. During 20x5, the company had 12 million in sales. Actual quality costs for 20x4 and 20x5 are as follows: Required: 1. Prepare an interim quality cost performance report for 20x5 that compares actual quality costs with budgeted quality costs. Comment on the firms ability to achieve its quality goals for the year. 2. Prepare a one-period quality performance report for 20x5 that compares the actual quality costs of 20x4 with the actual costs of 20x5. How much did profits change because of improved quality? 3. Prepare a graph that shows the trend in total quality costs as a percentage of sales since the inception of the quality improvement program. 4. Prepare a graph that shows the trend for all four quality cost categories for 20x1 through 20x5. How does this graph help management know that the reduction in total quality costs is attributable to quality improvements? 5. Assume that the company is preparing a second five-year plan to reduce quality costs to 2.5 percent of sales. Prepare a long-range quality cost performance report assuming sales of 15 million at the end of five years. Assume that the final planned relative distribution of quality costs is as follows: proofreading, 50 percent; other inspection, 13 percent; quality training, 30 percent; and quality reporting, 7 percent.
Forchen, Inc., provided the following information for two of its divisions for last year: Required: 1. For the Small Appliances Division, calculate: a. Average operating assets b. Margin c. Turnover d. Return on investment (ROI) 2. For the Cleaning Products Division, calculate: a. Average operating assets b. Margin c. Turnover d. Return on investment (ROI) 3. What if operating income for the Small Appliances Division was 2,000,000? How would that affect average operating assets? Margin? Turnover? ROI? Calculate any changed ratios (round to four significant digits).
If it can be done in excel, please, I would appreciate it very much (and show the formulas). For the purposes of the cash budget, projected balance method, it is necessary to calculate the depreciation for the year and for this purpose we have the following data: The balance of the Delivery Equipment account is $250,000.00; the Accumulated Depreciation of Delivery Equipment is $100,000.00; the depreciation method is straight-line; the company has been operating for two years. What is the amount of depreciation to be charged to income in the current fiscal year?
Upon receipt of the budget, the team manager, Hilux James, has now informed you that, in keeping with industry players, the management of Toyota & Sons have indicated an industry requirement to maintain a minimum cash balance of $155,000 each month. He has also noted that management is very keen on keeping the gearing ratio of the business as low as possible and would therefore prefer to cushion any gaps internally using equity financing. Based on the budget prepared, will the business be achieving this desired target? Suggest three (3) internal strategies that may be employed by management to improve the organization’s monthly cash flow and militate against or reduce any possible shortfall reflected in the budget prepared. Each strategy must be fully explained.
Upon receipt of the budget, the team manager, June Jackson, has now informed you that, in keeping with industry players, the management of Pelican Merchandising have indicated an industry requirement to maintain a minimum cash balance of $185,000 each month. She has also noted that management is very keen on keeping the gearing ratio of the business as low as possible and would therefore prefer to cushion any gaps internally using equity financing.Based on the budget prepared, will the business be achieving this desired target? Suggest three (3) internal strategies that may be employed by management to improve the organization’s monthly cash flow and militate against or reduce any possible shortfall reflected in the budget prepared. Each strategy must be fully explained.
The corporation you work for has asked for a summary and report of the future projections for the next 5 years. With the help of your CFO, you have put together the following preliminary budget figures based on last year's numbers for a planned production and sales level of 4,000 units per year: Building depreciation $200,000/yr. Machine operators $100,000/yr. Management staff $400,000/yr. Direct materials $4,000,000/yr. Other expenses that seem to vary based on production levels $3,000,000/yr. Other expenses that don't seem to vary $1,300,000/yr. Selling price per unit $5,000/unit Utilities: This category is difficult to analyze; a part of it is related to the building's heat and light, whereas a part of it is used in the manufacturing process itself. You have the following data to which you will apply the high–low method: When there is no production, utility costs are $20,000/month When production levels reached 4,000 units/month,…
Upon receipt of the budget (attached below), the team manager, June Jackson, has now informed you that, in keeping with industry players, the management of Pelican Merchandising have indicated an industry requirement to maintain a minimum cash balance of $185,000 each month. She has also noted that management is very keen on keeping the gearing ratio of the business as low as possible and would therefore prefer to cushion any gaps internally using equity financing. Based on the budget prepared (attached below), will the business be achieving this desired target? Suggest three (3) internal strategies that may be employed by management to improve the organization’s monthly cash flow and militate against or reduce any possible shortfall reflected in the budget prepared.
Rammazzotti, Inc., is looking for feedback on company performance. The company compares the budget for the year with the actual costs.Rammazzotti, Inc., had the following budgeted data: Unit sales for the year 26,000 Unit production for the year 26,000 Budgeted fixed overhead for the year: Supervision $ 800 Depreciation 2,000 Rent 100 Budgeted variable costs per unit: Direct materials $0.15 Direct labor 0.20 Supplies 0.02 Indirect labor 0.05 Power 0.02 The following actually occurred: Actual unit sales for the year 24,000 Actual unit production for the year 28,000 Actual fixed overhead for the year: Supervision $ 850 Depreciation 2,000 Rent 100 Actual variable costs: Direct materials $3,500 Direct labor 4,900 Supplies 530 Indirect labor 1,250 Power 470 The total budgeted costs for the year were a.$14,340. b.$11,440. c.$13,510. d.$13,460.