DB4

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 take next 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 margin Less operating expenses Net loss Direct materials Direct labor Manufacturing overhead Carolina Manufacturing Company Income Statement For the Year Ended December 31 Selling expenses Variable Sales commissi Shipping Fixed (advertisi Administrative expenses Variable (billing Fixed (salaries 135,000 117,450 147,750 40,500 8,100 180,000 2,700 72.000 $675,000 400,200 274,800…

Given the information below, answer questions 1-3. • Assume you are working on budgeting for the room department of your hotel. • Assume the hotel’s ‘Room Revenue (Sales)’ was $1,640,000 during 2019. Based on the lodging forecast report, you expect the ‘Room Revenue (Sales)’ to increase by 3.7% next year. • Assume the ‘Guest Supplies’ expenses (variable costs) from the room department was $246,000 during 2019. For 2020, this variable cost will remain at the same percentage of the Room Revenue (Sales) as experienced in 2019. • Assume the ‘Salaries’ expenses (fixed costs) from the room department was $280,000 during 2019. For 2020, this fixed cost will increase by 2% due to the expected increase in living expenses in this area.   1. What will be the budgeted ‘Room Revenue (Sales)’ for 2020 ($)?  Note: The Answer field only accepts numbers. Thus, do not include $ or commas when you type your answer.  Type your answer as a whole number (e.g., 200000).

Bramble Corp. prepared a 2022 budget for 228000 units of product. Actual production in 2022 was 160000 units. To be most useful, what amounts should a performance report for this company compare? The actual results for 160000 units with the original budget for 228000 units. The actual results for 160000 units with a new budget for 160000 units. The actual results for 160000 units with last year's actual results for 167600 units. O All of these comparisons are equally useful.

3. What will be the budgeted ‘Salaries’ expenses for 2020 ($)? Note: The Answer field only accepts numbers. Thus, do not include $ or commas when you type your answer.  Type your answer as a whole number (e.g., 200000).     • Assume you are working on budgeting for the room department of your hotel. • Assume the hotel’s ‘Room Revenue (Sales)’ was $1,640,000 during 2019. Based on the lodging forecast report, you expect the ‘Room Revenue (Sales)’ to increase by 3.7% next year. • Assume the ‘Guest Supplies’ expenses (variable costs) from the room department was $246,000 during 2019. For 2020, this variable cost will remain at the same percentage of the Room Revenue (Sales) as experienced in 2019. • Assume the ‘Salaries’ expenses (fixed costs) from the room department was $280,000 during 2019. For 2020, this fixed cost will increase by 2% due to the expected increase in living expenses in this area.

Crane Company has accumulated the following budget data for the year 2022. 1. Sales: 31,100 units, unit selling price $85. 2. Cost of one unit of finished goods: direct materials 1 pound at $5 per pound, direct labor 3 hours at $12 per hour, and manufacturing overhead $6 per direct labor hour. 3. Inventories (raw materials only): beginning, 10,100 pounds; ending, 15,100 pounds. 4. Selling and administrative expenses: $170,000; interest expense: $30,000. 5. Income taxes: 20% of income before income taxes.

2. What will be the budgeted ‘Guest Supplies’ expenses for 2020 ($)? • Assume you are working on budgeting for the room department of your hotel. • Assume the hotel’s ‘Room Revenue (Sales)’ was $1,640,000 during 2019. Based on the lodging forecast report, you expect the ‘Room Revenue (Sales)’ to increase by 3.7% next year. • Assume the ‘Guest Supplies’ expenses (variable costs) from the room department was $246,000 during 2019. For 2020, this variable cost will remain at the same percentage of the Room Revenue (Sales) as experienced in 2019. • Assume the ‘Salaries’ expenses (fixed costs) from the room department was $280,000 during 2019. For 2020, this fixed cost will increase by 2% due to the expected increase in living expenses in this area. Note: The Answer field only accepts numbers. Thus, do not include $ or commas when you type your answer.  Type your answer as a whole number (e.g., 200000).

Jay Draperies makes and sells curtains. Information related to its performance in 2020 is given below: (Click the icon to view the data.) Calculate Jay Draperies' flexible budget for (a) revenues, (b) variable costs, (c) fixed costs, and (d) operating income.

An assisted living has actual total revenues of 1.68 million, expenses of 1 million in 2018. The budgeted revenue was 1.7 million and the budgeted expenses were 900,000.  What is the net income for 2018? What is the revenue variance (in dollars or percentage) for 2018? What is the total margin for 2018?

Click Draperies makes and sells curtains. Information related to its performance in 2020 is given below: (Click the icon to view the data.) Calculate Click Draperies' flexible budget for (a) revenues, (b) variable costs, (c) fixed costs, and (d) operating income. Calculate Click's flexible budget for (a) revenues. Begin by determining the formula and then solve for the amount. Actual units sold 1,560 X Budgeted selling price per unit = Flexible budget for revenues × $ 361,920 232 Calculate Click's flexible budget for (b) variable costs. Begin by determining the formula and then solve for the amount. Actual units sold 1,560 X Budgeted variable cost per unit × $ 108 = Calculate Click's flexible budget for (c) fixed costs. Click's flexible budget for fixed costs is $ 73,000. = = Flexible budget for variable costs 168,480 Calculate Click's flexible budget for (d) operating income. Begin by determining the formula and then solve for the amount. (Abbreviations used: rev = revenue, vc =…

(b) Another team member who is preparing the Budgeted Balance Sheet for the business for the same quarter ending March 31, 2022 and has asked you to furnish him with the figures for the expected trade receivables and payables to be included in the statement. Is that a reasonable request? If yes, what should these amounts be?

please answer with complete and correct working thanks

Coronado Industries had sales in 2021 of $5,698,400 and gross profit of $921,800. Management is considering two alternative budget plans to increase its gross profit in 2022.Plan A would increase the unit selling price from $8.00 to $8.40. Sales volume would decrease by 104,750 units from its 2021 level. Plan B would decrease the unit selling price by $0.50. The marketing department expects that the sales volume would increase by 108,940 units.At the end of 2021, Coronado has 33,520 units of inventory on hand. If Plan A is accepted, the 2022 ending inventory should be 29,330 units. If Plan B is accepted, the ending inventory should be equal to 50,280 units. Each unit produced will cost $1.5 in direct labor, $1.3 in direct materials, and $1.2 in variable overhead. The fixed overhead for 2022 should be $1,588,010. Prepare a sales budget for 2022 under each plan.

Coronado Industries had sales in 2021 of $5,698,400 and gross profit of $921,800. Management is considering two alternative budget plans to increase its gross profit in 2022. Plan A would increase the unit selling price from $8.00 to $8.40. Sales volume would decrease by 104,750 units from its 2021 level. Plan B would decrease the unit selling price by $0.50. The marketing department expects that the sales volume would increase by 108,940 units. At the end of 2021, Coronado has 33,520 units of inventory on hand. If Plan A is accepted, the 2022 ending inventory should be 29,330 units. If Plan B is accepted, the ending inventory should be equal to 50,280 units. Each unit produced will cost $1.5 in direct labor, $1.3 in direct materials, and $1.2 in variable overhead. The fixed overhead for 2022 should be $1,588,010. Prepare a production budget for 2022 under each plan.

Subject: accounting

Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.