ACC 361 Topic 1 mixed cost estimation memo example

Intermediate Managerial Accounting Grand Canyon University Free custom sample in 24 to 48h

This ACC 361 Topic 1 sample paper is a mixed cost estimation memo to a plant controller comparing high-low and regression on a year of monthly maintenance cost and machine hours. It was written for GCU ACC 361, Intermediate Managerial Accounting, catalog code ACC-361, in the Grand Canyon University BS in Accounting. A scatter plot comes first and exposes June, inflated by a $2,000 breakdown repair. High-low, which happens to use June, gives $5.00 an hour on $6,000; regression over all twelve months gives $4.20 on $8,400. At the planned 4,000 hours the formulas differ by $800 a month, and the memo shows how that gap would become a variance on the maintenance supervisor's report.

CourseACC 361 Intermediate Managerial Accounting
TopicTopic 1
Paper typeMixed cost estimation memo
LengthAbout 760 words, 1 pages
FormatMemo with APA 7 references
SchoolGrand Canyon University (GCU)
ProgramBS in Accounting
UpdatedSeptember 2026

Free sample paper for ACC 361 Topic 1

1

Memorandum

To: Plant controller

From: [Author Name], cost analyst

Date: [Date]

Re: Estimating the maintenance cost formula for next quarter's flexible budget

 

Purpose

Maintenance is a mixed cost: part of it is fixed, the maintenance crew and service contracts, and part rises with machine use. Next quarter's flexible budget needs a formula of the form fixed cost plus a rate per machine hour. This memo estimates that formula from last year's twelve months of data by two methods, shows why they disagree and recommends one. All figures are illustrative.

The Data, Plotted First

Table 1 lists the twelve months. Plotted with machine hours on the horizontal axis and cost on the vertical, eleven months lie close to a straight line. June does not: it sits well above the line, because its $30,000 includes a $2,000 emergency gearbox repair after a breakdown, a cost unrelated to how many hours the machines ran. A scatter plot should always come before any formula, because it shows whether a straight line is sensible and whether any month does not belong (Garrison et al., 2021).

Table 1

Monthly Maintenance Cost and Machine Hours

MonthMachine hoursMaintenance cost
January3,200$22,351
February2,400$18,000
March3,600$23,545
April3,900$24,441
May4,100$25,039
June4,800$30,000
July4,400$25,935
August3,500$23,247
September3,000$21,753
October3,700$23,844
November4,200$25,337
December3,400$22,948

High-Low

High-low takes just two points, the busiest and the quietest month by machine hours. June had the most hours, 4,800, at $30,000; February the fewest, 2,400, at $18,000. The rate is the $12,000 difference in cost divided by the 2,400-hour difference in activity, or $5.00 an hour, and the fixed part is $30,000 less $5.00 times 4,800, or $6,000.

The problem is visible in the plot. The high point happens to be June, the month with the breakdown repair. High-low uses only two months, so an unusual cost in either one passes straight into the formula. Here the $2,000 repair raises the variable rate and lowers the fixed base.

Regression

Least-squares regression uses all twelve months and finds the line that minimizes the squared distances of all points from it. It gives $4.20 an hour on a fixed base of $8,400. Because every month contributes, the June repair has much less influence: it pulls the line up slightly but is balanced by eleven ordinary months. Regression is generally the more reliable method when data for many periods is available (Datar & Rajan, 2021). Excluding June entirely and rerunning would be defensible too, since its cost was caused by an event outside normal operations, and would move the estimate only slightly.

What the Disagreement Costs

Table 2 compares the two formulas at next quarter's planned 4,000 machine hours a month and at two lower volumes.

Table 2

Budgeted Maintenance Under Each Formula

At planned volumeHigh-lowRegressionDifference
Formula$6,000 + $5.00 per hour$8,400 + $4.20 per hour
One month at 4,000 hours$26,000$25,200$800
Quarter at 4,000 hours a month$78,000$75,600$2,400
One month at 3,000 hours$21,000$21,000None
One month at 2,400 hours$18,000$18,480$480 the other way

Reading the Gap

At the planned 4,000 hours, the high-low formula budgets $800 a month, $2,400 a quarter, more than regression. The two lines cross at 3,000 hours and diverge in the other direction below it. The gap is small relative to total maintenance of about $75,000 a quarter, but it does not stay in the budget. It becomes a variance on someone's report.

If the flexible budget used high-low and actual costs behaved as regression describes, the maintenance supervisor would show a favorable spending variance of about $800 each month at planned volume without having done anything differently. In a slow month at 2,400 hours, the same budget would show an unfavorable variance of about $480. Either way, the supervisor would be handed a variance created by the estimate, not by performance, and would be praised or questioned for it. A budget formula that misstates cost behavior misleads the people whose performance it is used to judge (Franklin et al., 2019).

Recommendation

Use the regression formula, $8,400 plus $4.20 per machine hour, in next quarter's flexible budget. Record the June repair as a one-time item so that it is not mistaken for normal cost behavior in next year's estimate, and update the regression each quarter as new months are added, so that the formula keeps pace with changes such as the new service contract that begins in the spring. If the plant later tracks breakdowns separately, they can be budgeted as their own line, which would make both the formula and the supervisor's variances cleaner.

References

Datar, S. M., & Rajan, M. V. (2021). Horngren's cost accounting: A managerial emphasis (17th ed.). Pearson.

Franklin, M., Graybeal, P., & Cooper, D. (2019). Principles of accounting, volume 2: Managerial accounting. OpenStax. https://openstax.org/details/books/principles-managerial-accounting

Garrison, R. H., Noreen, E. W., & Brewer, P. C. (2021). Managerial accounting (17th ed.). McGraw Hill.

Reading the GCU ACC 361 Topic 1 instructions

ACC-361 opens with Topic 1, where students estimate the behavior of a mixed cost. Many papers compute one formula without checking the data. The assignment rewards memos that plot the data first, compute estimates by more than one method, such as high-low and regression, and explain why they differ. Students should identify unusual observations and their effect on each method, compare the formulas at the planned level of activity, carry the difference into a budget, explain who would be affected by an estimate that misstates cost behavior and recommend a formula with reasons.

How this ACC 361 Topic 1 example is built

Addressed to the plant controller, the memo works from a year of monthly maintenance cost set beside machine hours, all figures illustrative. A scatter plot comes first, and it exposes one month inflated by a breakdown repair that had nothing to do with volume. The high-low method is computed from the two extreme months, which happen to include that outlier, and it yields a variable rate of $5.00 per hour on a fixed base of $6,000. Regression over all twelve months gives $4.20 per hour on $8,400. At the planned 4,000 hours the two formulas disagree by $800 a month, and the memo carries that gap into the quarter's budget. It closes by naming the maintenance supervisor as the person who would have been handed a variance the estimate itself created.

Where the marks sit in the ACC 361 Topic 1 rubric

GCU's rubric for the cost estimation memo rewards judgment about data. Excellent memos plot the months before estimating and notice an outlier that distorts high-low. Credit goes to regression over all periods and to explaining why it is less sensitive to one unusual month. The rubric values comparing the formulas at planned volume and showing where they cross. The highest level shows how an estimate error becomes a variance charged to a manager who did not cause it. Memos that report a high-low formula with no plot usually land in a middle band.

ACC 361 Topic 1 help: mistakes that cost marks

Marks slip away here when a formula is produced and never used for anything. A memo that reports a variable rate and a fixed amount, with no planned volume applied, has estimated a cost without informing a single budget line. High-low computed without looking at the data first will often rest on an abnormal month, and markers check whether the writer noticed. Regression output pasted in without the slope and intercept translated into cost language leaves the reader to do the interpretation. Recommending one method over the other on reputation alone, because regression sounds more sophisticated, misses the requirement to price what the rejected method would have cost. In many sections the rubric also asks for the relevant range, and a forecast made far outside the observed volumes quietly loses credit.

Get an ACC-361 Topic 1 example written to your instructions

Send the ACC-361 Topic 1 instructions, the rubric your classroom posts and the cost and activity data you were given. We write a custom example to them, with the data plotted, both estimation methods computed, the rejected formula priced at planned volume and the relevant range marked, back in 24 to 48 hours. The first one is free.

More ACC 361 papers and BS in Accounting samples

ACC 361 Topic 1 questions, answered

Why not always use regression?

Because the choice should rest on the data rather than on sophistication. Regression uses every observation, which usually makes it more reliable, but it is still pulled off course by an abnormal month left in the data set. Where the extreme months happen to be representative, high-low can land close to the regression line. The memo recommends a method by showing what each would do to the budget, not by ranking techniques.

What is the relevant range?

The span of activity over which the estimated cost behavior can be expected to hold. Fixed costs stay fixed only within it, since running far above the observed volumes may require another shift or a second machine. An estimate built from months between 2,000 and 5,000 machine hours says nothing reliable about 7,000, and the example flags any planned volume outside the history.

Does this topic repeat the introductory cost behavior material?

It starts from the same idea, that some costs move with activity and some do not, and then asks how the split is estimated from real records and what an error in the estimate costs. The introductory course usually supplies the fixed and variable amounts. Here the writer has to derive them, defend the method and follow the consequence into a budget someone will be judged against.

Where can I find a free ACC 361 Topic 1 sample paper?

Scroll up for the full memo, covering its purpose, the plotted data, high-low, regression, what the disagreement costs, reading the gap and the recommendation. Send your cost data for a free worked memo.

Why does high-low mislead in ACC 361 Topic 1?

Its high point is June, which includes a $2,000 breakdown repair unrelated to machine hours, so the one unusual month raises the rate and lowers the fixed base.