Define condensed monthly income data

Assignment Help Managerial Accounting
Reference no: EM13495407

Boundaries, a chain of retail stores, sell books and music CDs. Condensed monthly income data are presented in the following table for November 20X6. (ignore income taxes)

Downtown store Mall store Total
Sales $240,000- $360,000- $600,000-
less: variable expenses $96,000= $252,000= $348,000=
Contribution margin $144,000- $108,000- $252,000-
less: fixed expenses $60,000= $120,000= $180,000=
Operating income $84,000 ($12,000) $72,000

Additional information:

Management estimates that closing the mall store would result in a 10% decrease in downtown store sales, while closing the downtown store would not affect mall store sales. one-fourth of each store's fixed expenses would continue through December 31, 20x7, if either store were closed.

Build a spreadsheet: Construct an excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following information changes: the downtown store's sales amounted to $235,000, and its variable expenses were $90,000.

 

Reference no: EM13495407

Questions Cloud

Explain natural gas is a mixture of many substances : Natural gas is a mixture of many substances, primarily CH4, C2H6, C3H8, and C4H10. Assuming that the total pressure of gases is 1.48atm and that their mole ration is 94:4, 0:1, 5:0.50, calculate the partial pressure in atmospheres of each gas.
Explain ammonium nitrate can decompose explosively : Ammonium nitrate can decompose explosively when heated according to the equation: 2NH4NO3(s)-------2N2(g) + 4H2O(g) + O2(g) How many liters of gas would be formed at 4500C and 1.00 atm pressure by explosion of 450g of NH4NO3?
Explain which sample contains more molecules : Which sample contains more molecules, 3.14 L of Ar at 85.00C and 1111 mm Hg pressure or 11.07g of Cl2?
Explain gases are sold in steel cylinders : Many laboratory gases are sold in steel cylinders with a volume of 43.8L. What mass in grams of argon is inside a cylinder whose pressure is 17,180 kPa at 200C
Define condensed monthly income data : Build a spreadsheet: Construct an excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following information changes: the downtown store's sales amounted to $235,000, and its variable expenses were..
Explain what is its kelvin temperature : If 2.00g of N2 gas has a volume of 0.40L and a pressure of 6.0atm, what is its Kelvin temperature
Explain the volume of air in the tank in liters at stp : A compressed air tank carried by scuba divers has a volume of 8.0L and a pressure of 140 atm at 200C. what is the volume of air in the tank in liters at STP
Construct excel spreadsheet to solve preceding requirement : Canandaigua Container Company manufactures recyclable soft-drink cans. A unit of production is a case of 12 dozen cans. These following standards have been set by the production-engineering staff and the controller.
Evaluate the equilibrium concentration of all the gases : Calculate the equilibrium concentration of all the gases. This is the equation: 2NO(g)+2H2(g)=> N2(g)+2H2O(g). ( My instructor said that using the ICE table is a good method. if that helps in any way)

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd