| Course | ACC 260 Management Accounting |
|---|---|
| Topic | Topic 6 |
| Paper type | Linked budget schedules |
| Length | About 1,000 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 260 Topic 6
Every Total Starts the Next Schedule: Linked Budgets for Lantern Hill Candle Co. and the May Cash Gap They Reveal
[Author Name]
Colangelo College of Business, Grand Canyon University
ACC-260: Management Accounting
Topic 6 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.
Every Total Starts the Next Schedule: Linked Budgets for Lantern Hill Candle Co. and the May Cash Gap They Reveal
The Chain
Lantern Hill Candle Co., a composite maker of hand-poured candles, is preparing its budget for April through June. June sales are expected to jump for wedding season, and the owner plans to buy a second pouring station in May to meet it. A master budget links its schedules so that each total becomes the next schedule's starting line: sales drive production, production drives materials purchases, and all three, with their payment timing, drive the cash budget (Garrison et al., 2021). Each input in the schedules below is labeled with the person who owns it, since a budget is only as good as the estimates people are willing to stand behind. All figures are illustrative.
Schedule 1: Sales
Table 1
Sales Budget
| Sales budget | April | May | June | Input owner |
|---|---|---|---|---|
| Candles sold | 1,200 | 1,200 | 2,000 | Sales manager |
| Price per candle | $24 | $24 | $24 | Owner |
| Sales revenue | $28,800 | $28,800 | $48,000 |
March sales were 1,000 candles, or $24,000, and July sales are forecast at 1,400; both are needed by later schedules.
Schedule 2: Production
Operations agreed to hold 25% of the next month's sales in finished inventory at each month end. In April, 1,200 candles sold plus 300 held for May, less 240 already on the shelf, calls for 1,260 candles poured. May's pour rises to 1,400 because inventory is built ahead of June.
Table 2
Production Budget
| Production budget, candles | April | May | June | Input owner |
|---|---|---|---|---|
| Candles to be sold, from the sales budget | 1,200 | 1,200 | 2,000 | Sales manager |
| Add: desired ending inventory, 25% of next month's sales | 300 | 500 | 350 | Operations |
| Total needed | 1,500 | 1,700 | 2,350 | |
| Less: beginning inventory | 240 | 300 | 500 | Last month's ending |
| Candles to pour | 1,260 | 1,400 | 1,850 |
Schedule 3: Materials Purchases
Purchasing keeps enough wax, jars and wicks on hand for 20% of the next month's pour. June's purchase depends on July's planned pour of 1,350 candles.
Table 3
Materials Purchases Budget
| Materials purchases budget | April | May | June | Input owner |
|---|---|---|---|---|
| Candles to pour, from the production budget | 1,260 | 1,400 | 1,850 | Operations |
| Add: materials for 20% of next month's pour | 280 | 370 | 270 | Purchasing |
| Less: materials on hand at the start | 250 | 280 | 370 | Last month's ending |
| Candle sets to buy | 1,290 | 1,490 | 1,750 | |
| Cost at $5.00 a set: wax $3.00, jar and wick $2.00 | $6,450 | $7,450 | $8,750 | Purchasing |
Schedule 4: Cash
Collections and payments follow their actual timing, not the month of the sale or purchase. Customers pay 60% in the month of sale and 40% the next month; suppliers are paid half in the month of purchase and half the next. The owner wants at least $5,000 in the bank at every month end.
Table 4
Cash Budget With Financing
| Cash budget | April | May | June |
|---|---|---|---|
| Beginning cash | $8,000 | $14,215 | $5,965 |
| Collections: 60% of this month's sales, 40% of last month's | 26,880 | 28,800 | 40,320 |
| Payments for materials: 50% this month, 50% next | (6,125) | (6,950) | (8,100) |
| Pouring labor at $4 a candle | (5,040) | (5,600) | (7,400) |
| Fixed overhead: rent, utilities, salaries | (6,000) | (6,000) | (6,000) |
| Selling and administrative | (3,500) | (3,500) | (3,500) |
| Second pouring station | (18,000) | ||
| Cash before financing | 14,215 | 2,965 | 21,285 |
| Borrowing | 3,000 | ||
| Repayment and interest at 1% a month | (3,030) | ||
| Ending cash | $14,215 | $5,965 | $18,255 |
Checking the Links
Each link can be checked by carrying a total forward. The 1,260 candles to pour in April reappear as the first line of April's materials budget. April's 300 candles of ending inventory reappear as May's beginning inventory, and April's 280 sets of materials on hand reappear as May's starting materials. April's $6,450 of purchases reappears twice in the cash budget, half paid in April and half in May. April's $28,800 of sales reappears in April's collections at 60% and May's at 40%.
The links also show how a change travels. If the sales manager raised the June forecast by 200 candles, the May inventory target would rise by 50, May's pour and May's purchases would rise, and May's cash gap would widen before any extra June revenue arrived. That is why each input carries an owner: a change made in one schedule reaches the bank balance two schedules later.
What the Chain Reveals
April ends comfortably with $14,215. May does not. Collections in May reflect April's and May's modest sales, while May's spending includes the inventory build for June and the $18,000 pouring station. Cash before financing falls to $2,965, below the $5,000 minimum. June recovers strongly, because collections include 60% of the large June sales.
The gap would be invisible in any single schedule. The sales budget shows steady revenue, the production budget shows a sensible inventory build and the equipment purchase is justified by June's volume. Only when the schedules are linked through the cash budget does the timing problem appear: the business spends for June in May and is paid for June in June and July.
Recommendation: Size and Timing of Borrowing
The owner should arrange a short-term line of credit before May and draw $3,000 on the day the pouring station is paid for, bringing May's ending cash to $5,965. The draw can be repaid at the end of June from June's collections, with about $30 of interest at 1% a month, leaving $18,255. Because the gap is small relative to the forecast, the line should be sized at $6,000 rather than $3,000, to cover a plausible slip: if May collections fell 10% short, by about $2,880, cash before financing would drop to about $85, and the draw would need to be $5,000. A June shortfall is less dangerous; even with wedding orders 20% below forecast, June would collect about $5,760 less and still end near $12,500 after repaying the line.
Hansen et al. (2003) noted that budgeting serves planning and coordination as well as control, and that many firms have questioned rigid annual budgets. A rolling three-month cash budget like this one, updated each month as actual sales arrive, gives Lantern Hill the coordination benefit without locking it into forecasts that are already out of date (Franklin et al., 2019).
References
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.
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
Reading the GCU ACC 260 Topic 6 instructions
The Topic 6 instructions in ACC-260 ask students to prepare a master budget. Weak submissions present schedules that do not connect. The assignment rewards budgets in which each schedule's total becomes the next schedule's starting line, from sales to production, materials purchases and cash, with collections and payments on their actual timing. Students should label who owns each input, check the links by carrying totals forward, show how a change travels through the chain, identify any cash shortfall and recommend the size and timing of short-term borrowing with a margin for error.
How the ACC-260 Topic 6 example is put together
The finished budget is a chain of four schedules in which each total appears again as the next one's starting line. The sales schedule sets volume and price by month. The production schedule takes that volume, adds an ending inventory the managers agreed on, and subtracts what is already on the shelf: in the illustrative April, 1,200 candles sold plus 300 held for May less 240 on hand calls for 1,260 poured. Purchases of wax and wicks follow from production, and the cash schedule follows from sales collections and purchase payments on their actual timing. Every link is labeled with the department that owns the input. The cash schedule reveals a shortfall in the second month, and the example ends by recommending the size and timing of the short-term borrowing that covers it.
Where the marks sit in the ACC 260 Topic 6 rubric
Faculty grading the linked budgets reward connections that can be traced. Excellent budgets carry production into purchases and both into the cash budget, with ending inventories becoming next month's beginning balances. Credit goes to collections and payments timed as they actually occur and to a minimum cash balance. The rubric values showing how a forecast change reaches the bank balance. The highest level sizes the borrowing with a sensitivity test on collections and explains repayment timing. Budgets that compute cash from sales and purchases in the same month usually lose marks.
ACC 260 Topic 6 help: mistakes that cost marks
Budgets built as four unconnected tables are the characteristic loss here. When the production schedule uses a volume that is not the one on the sales schedule, the budget contradicts itself, and a marker who traces one number through the chain finds the break quickly. Ignoring the inventory policy, so that production simply equals sales, removes the step that makes the budget a coordination exercise at all. Cash schedules recording sales as cash in the month of sale overstate early receipts and hide the shortfall the scenario was written to produce. Assumptions scattered through the schedules without a source leave nobody accountable for the forecast. A cash budget showing a negative balance and then moving on, with no financing decision, treats the most important line in the quarter as a curiosity.
Get an ACC-260 Topic 6 example written to your instructions
Send the ACC-260 Topic 6 instructions, the rubric from your classroom and the forecast, policies and terms your scenario provides. A custom example gets prepared to those criteria, with the schedules linked in order, each input attributed, collections and payments timed correctly and a financing decision drawn from the cash budget, in 24 to 48 hours. There is no charge for the first one.
More ACC 260 papers and BS in Accounting samples
- ACC 260 Topic 1: Reporting Audience Comparison
- ACC 260 Topic 2: Cost Behavior Classification
- ACC 260 Topic 3: Contribution Format Restatement
- ACC 260 Topic 4: Break-even Assumptions Memo
- ACC 260 Topic 5: Sunk Cost Discussion Post
- ACC 260 Topic 7: Make-or-buy Decision Analysis
- ACC 260 Topic 8: Keep or Drop Recommendation
- ACC 335 Topic 6: User Access Rights Review
- ACC 250 Topic 6: Useful Life Comparison Memo
- ACC 337 Topic 6: Chart Choice Rationale
- ACC 240 Topic 6: Merchandising Entry Set
ACC 260 Topic 6 questions, answered
Why start with sales and not with costs?
Because almost every other figure in an operating budget depends on how much the company expects to sell. Production follows sales, purchases follow production and most variable costs follow both, so a budget started anywhere else has to guess at volume and then revise. The fixed costs can be listed independently, but even their adequacy is judged against the level of activity the sales forecast implies.
What is the inventory policy doing in a budget?
It is a decision somebody made about how much stock to hold, and it is the reason production differs from sales in any given month. Holding more protects against a stockout and ties up cash; holding less frees cash and risks lost sales. Stating the policy, and who set it, is part of what turns a forecast into a plan several managers have agreed to.
Is a cash shortfall a sign the budget is wrong?
Usually the reverse. A seasonal business often pays for materials before its customers pay for finished goods, and the cash budget exists to show that gap early enough to arrange financing. A shortfall the budget predicted is a planning success. One nobody noticed until the account was overdrawn is exactly what the schedule exists to head off.
Where can I find a free ACC 260 Topic 6 sample paper?
Everything is above: the chain, the sales, production, materials and cash schedules, checking the links, what the chain reveals and the borrowing recommendation. Send your budget data for free worked schedules.
Why does cash fall short in May in ACC 260 Topic 6?
May spends for June by building inventory and buying an $18,000 pouring station, while collections still reflect modest April and May sales.