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

  Making schedule of cost of good manufactured

Waterboys Corporation manufactured a variety of products in its factory. Data for the most recent months operations appear below:

  Explain how activity based costing could overcome

Explain how activity based costing could overcome the deficiencies in the existing costing system and use activity based costing to develop the cost for each activity centre.

  Marginal analysis for optimal decisions

Appalachian Coal Mining believes that it can increase labor productivity and, therefore, net revenue by reducing air pollution in its mines. It estimates that the marginal cost function for reducing air problem in its mines.

  Cost of manufacturing plant

My company plans to build a new manufacturing facility in 14 years. If my company estimates that today's cost is 543,219,876 and the annual inflation is 5%, how much will be the manufacturing plant cost in 14 years?

  Allocating joint costs of products

Joint costs should not be allocated to individual products for decision purposes. For what purposes are such costs allocated to products?

  Comfy chair company makes two types of chairs a lounge

comfy chair company makes two types of chairs a lounge chair and a folding beach chair. the company uses a job-order

  Prepare a budgeted income statement for june

Prepare a budgeted income statement for June and prepare a budgeted balance sheet as of June 30

  Cost of goods manufactured-cost of goods sold

During the year, the company purchased $100,000 of raw material and spent $340,000 on direct labor. Other data: Manufacturing overhead incurred $450,000; sales, $1,560,000; selling and administrative expenses, $90,000; income tax rate, 30%.

  The city of shipley maintains an employee retirement fund a

the city of shipley maintains an employee retirement fund a single-employer defined benefit plan that provides annuity

  Rank the services offered in order of their profitability

Determine the best sales mix. Rank the services offered in order of their profitability and which ranking would you recommend? What additional amount of total contribution margin would be generated if your recommendation were to be accepted?

  Question on company break-even point

Katara Enterprises distributes a single product whose selling price is $36 and whose variable expense is $24 per unit. The company's monthly fixed expense is $12,000.

  Mikes movie magic mike has been operating a small sole

mikes movie magic mike has been operating a small sole trader hire business for movies on dvds and blue ray disks with

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