ACC 260 Topic 6 linked budget schedules example

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

This ACC 260 Topic 6 sample paper is a chain of four linked budget schedules for a candle maker, April through June, in which each total starts the next schedule. It belongs to GCU ACC 260, Management Accounting, the course listed as ACC-260 in the Grand Canyon University BS in Accounting. Sales drive production, with 25 percent of next month's sales held in inventory, so April pours 1,260 candles. Production drives materials purchases, and all three drive a cash budget with 60/40 collections and 50/50 supplier payments. Every input names its owner. A second pouring station pushes May cash before financing to $2,965, and the paper recommends a $6,000 credit line with a $3,000 draw repaid in June.

CourseACC 260 Management Accounting
TopicTopic 6
Paper typeLinked budget schedules
LengthAbout 1,000 words, 2 pages
FormatAPA 7 student paper
SchoolGrand Canyon University (GCU)
ProgramBS in Accounting
UpdatedSeptember 2026

Free sample paper for ACC 260 Topic 6

1

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.

What this page is doingThe title describes how the four schedules connect and names the finding the chain produces. Lantern Hill Candle Co. and all figures are illustrative composites.
2

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 budgetAprilMayJuneInput owner
Candles sold1,2001,2002,000Sales manager
Price per candle$24$24$24Owner
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, candlesAprilMayJuneInput owner
Candles to be sold, from the sales budget1,2001,2002,000Sales manager
Add: desired ending inventory, 25% of next month's sales300500350Operations
Total needed1,5001,7002,350
Less: beginning inventory240300500Last month's ending
Candles to pour1,2601,4001,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 budgetAprilMayJuneInput owner
Candles to pour, from the production budget1,2601,4001,850Operations
Add: materials for 20% of next month's pour280370270Purchasing
Less: materials on hand at the start250280370Last month's ending
Candle sets to buy1,2901,4901,750
Cost at $5.00 a set: wax $3.00, jar and wick $2.00$6,450$7,450$8,750Purchasing

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 budgetAprilMayJune
Beginning cash$8,000$14,215$5,965
Collections: 60% of this month's sales, 40% of last month's26,88028,80040,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 financing14,2152,96521,285
Borrowing3,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 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.