Alden cos monthly cost and sales data for its operating

Assignment Help Financial Accounting

Reference no: EM13351895

Alden Co.'s monthly cost and sales data for its operating activities of the past year follow. Management wants to use these data to predict future fixed and variable costs.

Month Sales Total Cost Month Sales Total Cost

1 $325,000 $162,500 7 $355,000 $242,000

2 170,000 106,250 8 275,000 156,750

3 270,000 210,600 9 75,000 60,000

4 210,000 105,000 10 155,000 135,625

5 295,000 206,500 11 99,000 99,000

6 195,000 117,000 12 105,000 76,650

1. Purpose a Scatter diagram for these data with sales volume (in $) plotted on the total cost and horizontal axis plotted on the vertical axis

2. Evaluate both the variable costs per sales dollar and the total monthly fixed costs using the high-low method. Show the total cost line on the scatter diagram in part 1.

3. Use the evaluated line of cost behavior and results from part 2 to predict future total cost when sales volume is $380,00 and $420,000.

Reference no: EM13351895

Questions Cloud

Q1 what is the relationship between marginal cost and : q1. what is the relationship between marginal cost and marginal revenue when single-price monopoly maximize profit?

Purchase effective 31st december 2010 zintel corporation : purchase effective 31st december 2010 zintel corporation proposes to issue extra shares of its common stock in exchange

Q1 tetrangle manufacturing has fixed costs of 2160 per day : q1. tetrangle manufacturing has fixed costs of 2160 per day. the firm manufactures bicycle component upgrade kits. the

Q1 a 46 year-old man involved in a traffic accident is : q1. a 46 year-old man involved in a traffic accident is rushed to an emergency room with internal bleeding. assessment

Alden cos monthly cost and sales data for its operating : alden co.s monthly cost and sales data for its operating activities of the past year follow. management wants to use

Q1 scientists classify behaviours as either innate or : q1. scientists classify behaviours as either innate or learned depending on whether behaviour has been influenced by

Q on june 11 a 32-year-old hiker was bitten by a tick after : q. on june 11 a 32-year-old hiker was bitten by a tick. after 2 week he noticed an erythrematous ring at the location

You have been appointed as a consultant for thomas foods : you have been appointed as a consultant for thomas foods. thomas foods was incorporated in 1969. thomas foods sells

Q1 wanda owns a fish shop she employs students to sort and : q1. wanda owns a fish shop. she employs students to sort and pack the fish. students can pack the following amounts of

User Account

All Pages