ACC 361 Topic 2 cash budget shortfall analysis example

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

This ACC 361 Topic 2 sample paper builds seven linked schedules for a screen printer's growing second quarter and finds a cash shortfall in May. It belongs to GCU ACC 361, Intermediate Managerial Accounting, the course listed as ACC-361 in the Grand Canyon University BS in Accounting. Sales rise from $120,000 to $192,000, collections follow 30/70 terms, production and materials purchases rise with inventory policies and a second press is scheduled for May. Cash before financing falls to a $2,000 overdraft, $22,000 below the minimum. Three responses are costed: a credit line draw at about $440, delaying the press at about $1,500 and a customer discount at about $3,600 and rising.

CourseACC 361 Intermediate Managerial Accounting
TopicTopic 2
Paper typeCash budget shortfall analysis
LengthAbout 960 words, 2 pages
FormatAPA 7 student paper
SchoolGrand Canyon University (GCU)
ProgramBS in Accounting
UpdatedSeptember 2026

Free sample paper for ACC 361 Topic 2

1

Growth That Runs Out of Cash: A Seven-Schedule Quarter for Saguaro Sportswear and Three Ways to Cover the May Shortfall

[Author Name]

Colangelo College of Business, Grand Canyon University

ACC-361: Intermediate Managerial Accounting

Topic 2 Assignment

[Instructor Name]

[Date]

The organization, setting and figures below are a composite written as a model document. No real employer, client, colleague or patient is described.

What this page is doingThe title names the paradox the budget exposes, rising sales producing a cash gap, and promises that the responses are costed. Saguaro Sportswear and all figures are illustrative composites.
2

Growth That Runs Out of Cash: A Seven-Schedule Quarter for Saguaro Sportswear and Three Ways to Cover the May Shortfall

The Quarter and the Question

Saguaro Sportswear, a composite screen printer of team and event apparel, expects sales to rise sharply from April through June as spring leagues and summer events place orders. The owner assumed that more sales would mean more cash. This budget tests that assumption by building seven linked schedules, each with a note naming the schedule that supplied its input. Company policy sets a $20,000 floor on the month-end bank balance. All figures are illustrative.

Sales and Collections

Customers are mostly schools and leagues on 30-day terms: 30% pay in the month of sale and 70% the following month. A month of strong sales therefore shows up as cash mostly in the next month.

Table 1

Sales Budget

Schedule 1: salesAprilMayJune
Units, at $1210,00014,00016,000
Sales$120,000$168,000$192,000
SourceSales forecast; March sales were $96,000

Collections Schedule

Table 2

Cash Collections

Schedule 2: collectionsAprilMayJune
30% of this month's sales$36,000$50,400$57,600
70% of last month's sales67,20084,000117,600
Total collections$103,200$134,400$175,200
SourceSchedule 1 and credit terms

Collections in May reflect April's more modest sales, not May's surge. Of May's $168,000 of sales, only $50,400 arrives in May; the other $117,600 arrives in June, which is why June's cash position is so much stronger than May's even though June's spending is also higher.

Production and Materials

Saguaro keeps finished inventory equal to 20% of next month's sales and blank shirts and ink equal to 10% of next month's production, so rising sales pull production and purchases forward.

Table 3

Production Budget

Schedule 3: production, unitsAprilMayJune
Sales, Schedule 110,00014,00016,000
Add: ending inventory, 20% of next month's sales2,8003,2002,400
Less: beginning inventory2,0002,8003,200
Units to produce10,80014,40015,200

Materials Purchases

Table 4

Materials Purchases Budget

Schedule 4: materials purchasesAprilMayJune
Production, Schedule 310,80014,40015,200
Add: ending materials, 10% of next month's production1,4401,5201,160
Less: beginning materials1,0801,4401,520
Units to buy, blank shirt and ink at $4.0011,16014,48014,840
Purchases$44,640$57,920$59,360

June purchases use July's planned production of 11,600 units.

Payments

Saguaro settles each supplier invoice in two equal parts, one in the month it buys and one a month later. Labor, overhead and selling costs are paid in the month incurred, and a second printing press, needed for June's volume, is scheduled for May.

Table 5

Payments for Materials

Schedule 5: payments for materialsAprilMayJune
50% of this month's purchases$22,320$28,960$29,680
50% of last month's purchases20,00022,32028,960
Total$42,320$51,280$58,640
SourceSchedule 4; March purchases were $40,000

Other Disbursements

Table 6

Other Cash Disbursements

Schedule 6: other disbursementsAprilMayJune
Direct labor at $2.50 a unit, Schedule 3$27,000$36,000$38,000
Overhead: $18,000 plus $0.50 a unit23,40025,20025,600
Selling and administrative: $15,000 plus 5% of sales21,00023,40024,600
Second printing press30,000
Total$71,400$114,600$88,200

The press purchase is the single largest outflow in the quarter. It is scheduled for May so that the second press is installed and tested before June's peak, and that timing is what turns a tight month into a shortfall.

The Cash Budget

Table 7

Cash Budget Before Financing

Schedule 7: cash budgetAprilMayJune
Beginning cash$40,000$29,480$(2,000)
Collections, Schedule 2103,200134,400175,200
Payments for materials, Schedule 5(42,320)(51,280)(58,640)
Other disbursements, Schedule 6(71,400)(114,600)(88,200)
Ending cash before financing$29,480$(2,000)$26,360
Policy minimum20,00020,00020,000
Shortfall$22,000

The cash budget exposes the problem. In May, spending rises with production and the press purchase, while collections still reflect April. Cash before financing falls to a $2,000 overdraft, $22,000 below the policy minimum. June recovers as May's large sales are collected.

Three Responses, Costed

Table 8 compares three ways to close the May gap.

Table 8

Responses to the May Shortfall

ResponseHow it closes the gapCost
Draw $22,000 on the line of credit on May 1, repay June 30May ends at the $20,000 minimum; June ends at $25,920 after repaymentAbout $440 of interest at 1% a month
Delay the press purchase from May to JuneMay ends at $28,000; June ends at $26,360About $1,500 of outsourced printing for June orders the old press cannot handle
Offer customers 2% off for payment in the month of saleRaises in-month collections to about 50%; May ends near $29,900About $3,600 of discounts in May and June, and about $1,900 a month after that

Recommendation

The line of credit is the cheapest response by a wide margin: about $440 of interest for two months, against about $1,500 for delaying the press and about $3,600 for the discount in the first two months alone. The discount is also the hardest to reverse, since customers who receive it once will expect it again, and at about $1,900 a month it would cost more than $20,000 a year. Delaying the press risks late deliveries in June, Saguaro's busiest month, which could cost customers as well as money.

The owner should arrange a line of credit of at least $30,000 before May, to leave room if collections run slower than 30% in the month of sale, and draw $22,000 at the start of May. The deeper lesson is that growth consumes cash before it produces it: inventory and receivables must be financed before the sales they support are collected (Garrison et al., 2021). A cash budget built from linked schedules is what shows the timing, which is why many firms maintain one on a rolling basis even when they have moved away from rigid annual budgets (Hansen et al., 2003). Because each schedule names its source, a change in the sales forecast can be traced through to the cash balance within minutes (Datar & Rajan, 2021).

References

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

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

Hansen, S. C., Otley, D. T., & Van der Stede, W. A. (2003). Practice developments in budgeting: An overview and research perspective. Journal of Management Accounting Research, 15(1), 95-116. https://doi.org/10.2308/jmar.2003.15.1.95

The ACC-361 Topic 2 assignment instructions

The Topic 2 instructions in ACC-361 ask students to prepare a master budget and use the cash budget to plan financing. Weak submissions compute cash from sales and costs in the same month. The assignment rewards linked schedules for sales, collections, production, materials purchases, payments, other disbursements and cash, each noting the schedule that supplies its input. Students should show how growth pulls spending ahead of collections, identify any month below the minimum balance, cost several responses against each other and recommend one with a margin for error.

Inside the ACC 361 Topic 2 example

On the page sit seven schedules for one quarter, with illustrative figures and a reference line under each naming the schedule that supplied its input. Forecast sales drive production once desired ending inventory is added, production drives materials purchases, and purchases drive the disbursement pattern. Collections follow the stated credit terms, so a month of strong sales shows up as cash only partly in that month and mostly in the one after. The cash budget then exposes the problem: rising sales pull purchases forward while collections lag, and the balance falls below the policy minimum in the second month. Three responses are costed against each other: drawing on a line of credit, delaying a planned equipment purchase by one month and offering customers an early-payment discount. The chosen response is defended, and both rejected ones carry their price.

ACC 361 Topic 2 rubric: what Excellent looks like

Faculty grading the cash budget reward schedules that link and responses that are priced. Excellent budgets carry production into purchases and purchases into payments with the stated timing. Credit goes to explaining why rising sales can create a shortfall. The rubric values comparing borrowing, delaying spending and offering discounts on cost and on how hard each is to reverse. The highest level sizes a credit line with room for slower collections. Budgets that treat all sales as cash in the month of sale usually lose marks.

Common ACC 361 Topic 2 mistakes, and how to avoid them

Budgets in this topic lose credit where one schedule stops talking to another. A production schedule that ignores the ending inventory policy produces purchases and labor figures that are consistently wrong, and every later schedule inherits the error. Collections entered in the month of sale, regardless of the credit terms given, hide the very shortfall the cash budget exists to show. Depreciation carried into disbursements overstates the cash needed and is marked as a misunderstanding rather than a slip. Analyses that find the shortfall and stop there leave the decision undone, and a recommendation with no cost set against the rejected options is an opinion about financing. Sections frequently expect the minimum cash balance to hold in every month, so a plan that dips below it without comment is incomplete.

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

Send your ACC-361 Topic 2 instructions, the rubric and the sales forecast or budget data your section supplied. We write a custom example to them, with every schedule linked to its source, collections timed to the credit terms, the shortfall located and each response costed, in 24 to 48 hours. The first one costs nothing.

More ACC 361 papers and BS in Accounting samples

ACC 361 Topic 2 questions, answered

Why can a profitable budget run out of cash?

Because profit is measured on an accrual basis and cash moves on its own timetable. When sales grow, the business buys materials and pays labor before customers pay for the goods, so cash goes out ahead of the receipts that will eventually cover it. The budgeted income statement shows the profit in the month of sale; the cash budget shows the gap in between.

Which schedule should be built first?

The sales budget, since every other schedule depends on it directly or through production. Production needs forecast sales and the inventory policy; materials and labor need production; collections need sales and the credit terms; disbursements need purchases and payroll. Building in that order means a change to the forecast can be carried through the whole plan instead of patched into one schedule.

Is borrowing always the right answer to a shortfall?

Not automatically. The example prices each alternative because a short draw on a credit line may cost less than delaying equipment that would have raised output, or more than a modest discount that speeds collections. The right answer depends on the figures and on the risk each response carries, and rubrics commonly want that comparison on the page.

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

The complete budget sits above, with the quarter, sales and collections, production and materials, payments, the cash budget, three costed responses and the recommendation. Share your budget data for a free worked analysis.

Why does cash run short in May in ACC 361 Topic 2?

May's spending rises with production and a press purchase, but its collections still reflect April's smaller sales, since 70 percent of each month's sales arrive the following month.