| Course | ACC 361 Intermediate Managerial Accounting |
|---|---|
| Topic | Topic 2 |
| Paper type | Cash budget shortfall analysis |
| Length | About 960 words, 2 pages |
| Format | APA 7 student paper |
| School | Grand Canyon University (GCU) |
| Program | BS in Accounting |
| Updated | September 2026 |
Free sample paper for ACC 361 Topic 2
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.
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: sales | April | May | June |
|---|---|---|---|
| Units, at $12 | 10,000 | 14,000 | 16,000 |
| Sales | $120,000 | $168,000 | $192,000 |
| Source | Sales forecast; March sales were $96,000 |
Collections Schedule
Table 2
Cash Collections
| Schedule 2: collections | April | May | June |
|---|---|---|---|
| 30% of this month's sales | $36,000 | $50,400 | $57,600 |
| 70% of last month's sales | 67,200 | 84,000 | 117,600 |
| Total collections | $103,200 | $134,400 | $175,200 |
| Source | Schedule 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, units | April | May | June |
|---|---|---|---|
| Sales, Schedule 1 | 10,000 | 14,000 | 16,000 |
| Add: ending inventory, 20% of next month's sales | 2,800 | 3,200 | 2,400 |
| Less: beginning inventory | 2,000 | 2,800 | 3,200 |
| Units to produce | 10,800 | 14,400 | 15,200 |
Materials Purchases
Table 4
Materials Purchases Budget
| Schedule 4: materials purchases | April | May | June |
|---|---|---|---|
| Production, Schedule 3 | 10,800 | 14,400 | 15,200 |
| Add: ending materials, 10% of next month's production | 1,440 | 1,520 | 1,160 |
| Less: beginning materials | 1,080 | 1,440 | 1,520 |
| Units to buy, blank shirt and ink at $4.00 | 11,160 | 14,480 | 14,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 materials | April | May | June |
|---|---|---|---|
| 50% of this month's purchases | $22,320 | $28,960 | $29,680 |
| 50% of last month's purchases | 20,000 | 22,320 | 28,960 |
| Total | $42,320 | $51,280 | $58,640 |
| Source | Schedule 4; March purchases were $40,000 |
Other Disbursements
Table 6
Other Cash Disbursements
| Schedule 6: other disbursements | April | May | June |
|---|---|---|---|
| Direct labor at $2.50 a unit, Schedule 3 | $27,000 | $36,000 | $38,000 |
| Overhead: $18,000 plus $0.50 a unit | 23,400 | 25,200 | 25,600 |
| Selling and administrative: $15,000 plus 5% of sales | 21,000 | 23,400 | 24,600 |
| Second printing press | 30,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 budget | April | May | June |
|---|---|---|---|
| Beginning cash | $40,000 | $29,480 | $(2,000) |
| Collections, Schedule 2 | 103,200 | 134,400 | 175,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 minimum | 20,000 | 20,000 | 20,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
| Response | How it closes the gap | Cost |
|---|---|---|
| Draw $22,000 on the line of credit on May 1, repay June 30 | May ends at the $20,000 minimum; June ends at $25,920 after repayment | About $440 of interest at 1% a month |
| Delay the press purchase from May to June | May ends at $28,000; June ends at $26,360 | About $1,500 of outsourced printing for June orders the old press cannot handle |
| Offer customers 2% off for payment in the month of sale | Raises in-month collections to about 50%; May ends near $29,900 | About $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 1: Mixed Cost Estimation Memo
- ACC 361 Topic 3: Flexible Budget Performance Report
- ACC 361 Topic 4: Materials and Labor Variance Analysis
- ACC 361 Topic 5: Variance Ownership Discussion Post
- ACC 361 Topic 6: Segment Margin Report
- ACC 361 Topic 7: Residual Income Comparison
- ACC 361 Topic 8: Control System Incentive Review
- ACC 360 Topic 2: Job Cost Sheet
- ACC 337 Topic 2: Data Preparation Log
- ACC 335 Topic 2: Expenditure Cycle Flowchart
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.