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

  Inventory control in a merchandising division

Adding certain controls costing $35,000 annually could reduce these losses to 0.5 percent of purchases. Should the control be recommended?

  Liabilitiesthe following items are extracted in a random

liabilitiesthe following items are extracted in a random order from the accounting records of mst corp for the period

  Determining the traditional costing-activity based costing

K's Cornerspot, a popular university eatery in a competitive market, has seating & staff capacity to serve about 600 lunch customers every day. For the past 2 months, demand has fallen from its previous near-capacity level. Concerned about his dec..

  Genmed hospital needs to replace its existing mri scanning

genmed hospital needs to replace its existing mri scanning machine. the hospital is considering funding the purchase by

  Should whardale implement the quality program

Classify each of these costs into one of four categories of quality costs (prevention, appraisal, internal failure, external failure)

  Stage cost allocation system

Construct a diagram of a two-stage cost allocation system for Web-books.com. Identify each activity pool in your model as unit-level, batch-level, product-level or facility-level.

  What would be the maximum purchase price acceptable

What qualitative factors (that is, issues with vendors, customers, or within the product itself) should the Ski Pro Corporation consider in determining whether they should make or buy the bindings?

  Explain cost-volume-profit analysis

Describe cost-volume-profit analysis, including the explanation of the calculation and components. In what three ways can the contribution margin be useful in cost-volume-profit analysis?

  Relevant costs-special sales order

Hull Motors, Inc. (HMI), produces small gasoline-powered motors for use in lawn mowers. The company has been growing steadily over the past five years and is operating at full capacity.

  Standard costs and plans for fiscal current year

Spam Inc. had the following standard costs and plans for fiscal current year for the production' of custom meat products Plan 500,000 Plan Direct Material

  Question-fixed overhead budget variance

Jessep Corporation has a standard cost system in which manufacturing overhead is applied to units of product on the basis of direct labor hours. The company has provided the following data concerning its fixed manufacturing overhead costs in March..

  Questionnbsp dr catscan is an ophthalmologist who in

questionnbsp dr catscan is an ophthalmologist who in addition to prescribing glasses and contact lenses performs

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