Chapter 7



Answers to Questions

1. Budgets are useful for large companies with complex activities as well as small companies. Budgets act as a vehicle for communication by formalizing management’s plans in a document that communicates company objectives. The benefits associated with this kind of planning apply to all sizes of companies operating at all levels of complexity.

2. The budget represents the companywide plans stated in financial terms as to how to coordinate operating activities to accomplish goals and objectives. Accordingly, its success depends upon the combined effort of all of the parties involved. A committee that includes representatives from all pertinent departments is necessary to formulate the master budget.

3. The three levels of planning are as follows:

1) Strategic planning – the long-run planning activities that address issues such as overall company goals and objectives.

2) Capital budgeting – the intermediate financial planning activities of the entire company that concern investments, product selection, and desired profitability.

3) Operations budgeting – the short-run financial planning for the company’s different departments that culminates in the formation of a master budget.

4. The span of time is the primary factor that distinguishes the three levels of planning from each other. Strategic planning involves long-range decisions; capital budgeting is associated with intermediate-range plans; and operational budgeting is concerned with short-range plans.

5. The perpetual budget has the advantage of keeping management involved in the budget process. Too often budgets are prepared and forgotten. The perpetual budget forces management to maintain a constant focus on the company’s goals and objectives.

6. The primary advantages associated with budgeting are as follows:

Planning – formalizes management’s plans in a document that communicates company objectives.

Coordination – forces departments to coordinate their activities in a manner that ensures the attainment of the objectives of the whole company.

Performance measurement – represents specific, quantitative standards that can be used to evaluate performance.

Corrective action – acts as an early warning system that promotes corrective action.

7. Budgeted amounts represent management’s expectations regarding how the firm as a whole and individual departments within the firm should perform. By comparing actual performance with the expected performance (the budgeted amounts), managers can be effectively evaluated.

8. Mr. Shilov’s failure with budgets seems to stem from his misunderstanding of the human element. He states that “he made budgets.” Experience shows that, in general, employees are more willing to accept budget standards if they participate in the budgeting process. Further, Mr. Shilov appears to have used the budget as a tool for punishment – a basis for reprimanding employees. As a result, employees would resent the budget and would be unmotivated to accomplish budget standards.

9. A master budget consists of a series of detailed schedules and budgets that describe the overall financial plans for the forthcoming accounting period.

10. The sales forecast normally functions as the starting point for the development of the master budget. Clearly, production and other related activities depend upon the level of sales.

11. The desired level of ending inventory must be added to projected sales in order to determine the amount of goods that are needed during the period. The beginning inventory is subtracted from the amount of goods needed in order to determine the amount of goods to be produced. Managing inventory is important because an inventory shortage can result in customer dissatisfaction and loss of sales. Conversely, excess inventory ties up capital investment, creates unnecessary storage cost, and is subject to obsolescence or spoilage. Finding the balance between too much and too little inventory is essential to the profitability of a company.

12. The cash budget is composed of three major components:

1) Cash receipts – expected cash inflows from sales, sale of investments, and borrowing activities, etc.

2) Cash payments – expected cash outflows for inventory purchases, selling and administrative expenses, and purchases of investments, etc.

3) Financing activities – expected borrowing and repayment activities.

13. Determining the amount of the cash balance to include on the budgeted balance sheet is an insignificant reason for preparing a cash budget. The real purpose of preparing a cash budget is to enable a company to effectively manage its financing and investing activities. If the company can foresee a cash surplus then investment opportunities can be investigated to earn interest or debt can be repaid to reduce interest. If the company anticipates a cash shortage, appropriate sources of financing can be investigated to avoid possible bankruptcy. When dealing with large amounts of money, investing, borrowing, and repayment activities that involve interest can be critical to profitability.

14. The pro forma income statement provides information about the expected profitability of the company. The completion of this statement is dependent on the departmental operating budgets. For example, the sales budget provides information about projected sales revenues, the purchases budget provides information as to projected cost of goods sold, the selling and administrative expenses budget provides information about projected operating expenses, and the cash budget provides information as to expected interest revenue and expense.

15. The cash budget, like the pro forma statement of cash flows, provides information as to expected cash receipts and cash payments, but in addition it shows how a firm plans to effectively manage its cash through financing and investing activities.

Exercise 7-1A

Ms. Weller appears to be a person with an attitude problem. She does not understand how to involve her colleagues in the budgeting process. She degrades their input and uses the budget as a tool for criticism. In so doing, Ms. Weller has failed to gain the support of upper-level management. The attitudes of upper-level management will have a significant impact on the effectiveness of the budget. Subordinates develop a keen awareness of management's expectations. If upper-level managers degrade, make fun of, or ignore the budget, subordinates will rapidly follow suit. If budgets are used to humiliate or embarrass subordinates, they will resent the treatment and the budgeting process that enables it. To be effective, upper-level management must accept and portray the budget as a sincere effort to express realistic goals that employees will be expected to accomplish. The proper atmosphere is essential to budgeting success. Once a negative pattern has been established, it is difficult to change. Perhaps the most effective solution in this case is to replace Ms. Weller.

Exercise 7-2A

a.

|Sales Budget | | | | |

| |January |February |March | |

|Cash sales |$ 60,000 |$ 66,000 |$ 72,600 | |

|Sales on account |140,000 |154,000 |169,400 | |

|Total budgeted sales |$200,000 |$220,000 |$242,000 | |

| | | | | |

b. The amount of sales revenue appearing on the 1st quarter income statement is the sum of the monthly amounts ($200,000 + $220,000 + $242,000 = $662,000).

Exercise 7-3A

a.

|Schedule of Cash Receipts |July |August |September | |

|Current cash sales |$ 80,000 |$ 85,000 |$ 90,000 | |

|Plus collections from accounts receivable |100,000 |90,000 |108,000 | |

|Total budgeted collections |$180,000 |$175,000 |$198,000 | |

| | | | | |

b. The current month’s sales on account will be collected in the following month. Accordingly, the amount of accounts receivable at the end of September is equal to September’s sales on account ($129,600).

Exercise 7-4A

a.

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |

|East Div. |$150,000 |$156,000 |$162,240 |$168,730* |

|West Div. |250,000 |255,000 |260,100 |265,302 |

|South Div. | 200,000 | 210,000 | 220,500 | 231,525 |

|Total |$600,000 |$621,000 |$642,840 |$665,557 |

| | | | | |

*Rounded

b.

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |

|Total |$600,000 |$621,000 |$642,840 |$665,557 |

| | | | | |

Exercise 7-5A

a. Sales for January are expected to be $560,000 ($800,000 x 0.70)

| | |

|Beginning accounts receivable balance |$120,000 |

|January sales on account |560,000 |

|Available for collection |680,000 |

|Less: Ending accounts receivable balance |(82,000) |

|Cash collected |$598,000 |

b. It is reasonable to assume that sales will decline in January. Customers tend to buy merchandise in December for Christmas gifts and to cut back on buying in January immediately after Christmas.

Exercise 7-6A

Sales would likely be highest in late January or early February because of Valentine’s Day sales. October may also produce higher sales due to buying for Halloween. Other holiday seasons are also likely to boost sales. Accordingly, sales would be high in April for Easter, and November and December for Christmas and Hanukah. Months that would be lower would be May and June. Summer months may pick up due to children being out of school and in the malls. Similarly, sales would be expected to drop off in August and September when school reopens.

Exercise 7-7A

a.

|Inventory Purchases Budget | | | | |

| |January |February |March | |

|Budgeted cost of goods sold |$60,000 |$ 64,000 |$70,000 | |

|Plus: Desired ending inventory |6,400 |7,000 |8,000 | |

|Total inventory needed |66,400 |71,000 |78,000 | |

|Less: Beginning inventory |6,000 |6,400 |7,000 | |

|Required purchases (on account) |$60,400 |$ 64,600 |$71,000 | |

| | | | | |

Exercise 7-7A (continued)

b. The amount of cost of goods sold appearing on the first quarter pro forma income statement is the sum of the monthly amounts ($60,000 + $64,000 + $70,000 = $194,000).

c. Since the quarter ends on March 31, the ending inventory for March is also the ending inventory for the quarter, $8,000.

Exercise 7-8A

a.

|Schedule of Cash Payments for Inventory Purchases | |

| |April |May |June | |

|Payment for current accounts payable |$126,000 |$144,000 |$171,000 | |

|Payment for previous accounts payable |8,000 |14,000 |16,000 | |

|Total budgeted payments for inventory |$134,000 |$158,000 |$187,000 | |

| | | | | |

b. Since 90% of the current purchases on account are paid in cash during the month of purchase, 10% will remain payable at the end of the month, $19,000 ($190,000 x 0.10).

Exercise 7-9A

a. Budgeted cost goods sold for July is $420,000 ($400,000 x 1.05)

|Ending inventory balance |$ 32,000 |

|Budgeted cost of goods sold |420,000 |

|Total inventory needed |452,000 |

|Less: Beginning inventory balance |(30,000) |

|Budgeted purchases |$422,000 |

b.

|June’s payables balance paid in July |$ 36,000 |

|Cash paid for July purchases ($422,000 x 0.70) |295,400 |

|Projected cash payments for July |$331,400 |

Exercise 7-10A

a. An inventory purchases budget prepared with the sales manager's estimate:

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |

|Sales |$450,000 |$360,000 |$320,000 |$540,000 |

|Cost of goods sold |$270,000 |$216,000 |$192,000 |$324,000 |

|Plus: Desired ending inventory |21,600 |19,200 |32,400 |36,000 |

|Total inventory needed |291,600 |235,200 |224,400 |360,000 |

|Less: Beginning inventory |30,000 |21,600 |19,200 |22,440 |

|Required purchases |$261,600 |$213,600 |$205,200 |$337,560 |

| | | | | |

b. An inventory purchases budget prepared with the marketing consultant's estimate:

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |

|Sales |$600,000 |$480,000 |$420,000 |$700,000 |

|Cost of goods sold |$360,000 |$288,000 |$252,000 |420,000 |

|Plus: Desired ending inventory |28,800 |25,200 |42,000 |36,000 |

|Total inventory needed |388,800 |313,200 |294,000 |456,000 |

|Less: Beginning inventory |30,000 |28,800 |25,200 |42,000 |

|Required purchases |$358,800 |$284,400 |$268,800 |$414,000 |

| | | | | |

Exercise 7-11A

a.

|Schedule of Cash Payments for S&A Expenses | | |

| |Oct. |Nov. |Dec. | |

|Equipment lease expense |$7,500 |$ 7,500 |$ 7,500 | |

|Prior month's salary expense, 100% |0 |8,200 |8,700 | |

|Cleaning supplies |2,800 |2,730 |3,066 | |

|Insurance premium |7,200 |0 |0 | |

|Rent |1,700 |1,700 |1,700 | |

|Miscellaneous expenses |700 |700 |700 | |

|Total payments for S&A expenses |$19,900 |$20,830 |$21,666 | |

|Depreciation is a noncash charge. | | | | |

Exercise 7-11A

b. Since salaries expense is paid in the month following the month it is incurred, the amount payable at the end of December will be the amount of salary expense incurred in December, $9,000.

c. Since the insurance premium is prepaid for 6 months on October 1, the amount of prepaid insurance at the end of December will be $3,600 [$7,200 – ($1,200 x 3)].

Exercise 7-12A

|a. Budgeted payments for January: | |

| Sales commissions |$40,000 |

| Rent |24,000 |

| Miscellaneous |2,000 |

| Total* |$66,000 |

*The amount of utilities is not included because the cash payment will be made in February. The amount of depreciation is not included because the depreciation does not require a cash payment. Recall that cash is paid at the time of purchase rather than when the depreciation is recognized.

b. The full $8,000 balance for the utilities charge will remain payable at the end of January.

c. The problem implies that the monthly charge for depreciation is $4,000. Accordingly, the amount of depreciation to be recognized on an annual income statement would be $48,000 ($4,000 x 12).

Exercise 7-13A

a.

|Cash Budget |July |August |September | |

|Section 1: Cash receipts | | | | |

|Beginning cash balance |$ 50,000 |$ 20,000 |$ 20,000 | |

|Add cash receipts |180,000 |200,000 |240,600 | |

|Total cash available (a) |230,000 |220,000 |260,600 | |

|Sections 2: Cash Payments | | | | |

|For inventory purchases |165,500 |140,230 |174,152 | |

|For S&A expenses |54,500 |60,560 |61,432 | |

|For interest exp at 1% per month |0 |1001 |1092 | |

|Total budgeted disbursements (b) |220,000 |200,890 |235,693 | |

|Sections 3: Financing Activities | | | | |

|Cash surplus (shortage) (a – b=c) |10,000 |19,110 |24,907 | |

|Borrowing (repayment) (d–c) |10,000 |890 |(4,907) | |

|Ending cash balance (d) |$ 20,000 |$ 20,000 |$ 20,000 | |

| | | | | |

110,000 x 1% = 100 (rounded)

2(10,000 + 890) x 1% = 109 (rounded). Note that $4,907 is repaid at the end of month, in addition to interest, that still has to be paid in September.

b. Cash flow from operating activities is equal to total (i.e., sum of the monthly amounts) cash receipts from customers minus the total (i.e., sum of the monthly amounts) of cash payments for inventory, S&A expense, and interest [i.e., $620,600 – ($220,000 + $200,890 + $235,693) = ($35,983) net cash outflow.]

c. Cash flow from financing activities is the amount borrowed less repayments (i.e., $10,000 + $890 – $4,907 = $5,983 net cash inflow.)

Exercise 7-14A

a.

|Cash Collections | | |

| Collections from May’s receivables balance |$ 80,000 | |

| Collections from June’s credit sales ($500,000 x .80) |400,000 | |

| Cash sales from June |200,000 | |

| Total cash receipts | |$680,000 |

|Desired cash balance |30,000 | |

|Cash disbursements |660,000 | |

|Total cash needs | |690,000 |

|Cash shortage (amount needed to be borrowed) | |$ 10,000 |

b. The interest expense for June is $0 because the loan is taken at the end of June.

c. The interest expense for July is $75 ($10,000 x 9% ÷ 12).

Exercise 7-15A

a. Pro forma income statement prepared with Mr. Meier’s estimate:

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |Total |

|Cost of goods sold |116,640 |129,600 |136,080 |168,480 |550,800 |

|Gross profit |77,760 |86,400 |90,720 |112,320 |367,200 |

|S. & Adm. expenses |19,440 |21,600 |22,680 |28,080 |91,800 |

|Net income |$ 58,320 |$ 64,800 |$ 68,040 |$ 84,240 |$275,400 |

| | | | | | |

b. Pro forma income statement prepared with Ms. Odom's estimate:

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |Total |

|Cost of goods sold |113,400 |126,000 |132,300 |163,800 |535,500 |

|Gross Profit |75,600 |84,000 |88,200 |109,200 |357,000 |

|S & A expenses |18,900 |21,000 |22,050 |27,300 |89,250 |

|Net income |$ 56,700 |$ 63,000 |$ 66,150 |$ 81,900 |$267,750 |

| | | | | | |

c. Forecasting is not likely to be 100% accurate. Therefore, different executive officers within the same company may have different estimates about the future. In addition to legitimate differences caused by honest opinions, self-interest may also contribute to differences. For example, Ashley Odom may want to establish low budgetary figures for sales because these figures will become the standards for the evaluation of Ashley's future performance. With low standards, she would have a better chance of reaching the standards.

Problem 7-16A

a. Pro forma income statement assuming 5% growth:

| |Budget |

|Sales revenue |$2,100,000 |

|Cost of goods sold |1,312,500 |

|Gross profit |787,500 |

|Selling & administrative expenses |472,500 |

|Net income |$ 315,000 |

| | |

b. Pro forma income statement with 10% growth:

| |Actual Result |

|Sales revenue |$2,200,000 |

|Cost of goods sold |1,375,000 |

|Gross profit |825,000 |

|Selling & administrative expenses |495,000 |

|Net income |$ 330,000 |

| | |

Excess of actual net income over budget:

$330,000 – $315,000 = $15,000

Bonus: $15,000 x 15% = $2,250

c. Pro forma income statement assuming 15% growth:

| |Budget |

|Sales revenue |$2,300,000 |

|Cost of goods sold |1,437,500 |

|Gross profit |862,500 |

|Selling & administrative expenses |517,500 |

|Net income |$ 345,000 |

| | |

d. Zero

Problem 7-16A (continued)

e. The process of participative budgeting is recommended. This process requires two-way communication between the president and divisional vice presidents. Any disagreement about the budget assumptions should be fully discussed and pros and cons well considered. If the president believes that the divisional budget is unrealistic, he should tell the vice president directly and explain the reasons. Participative budgeting is more than just a budget proposal from a subordinate and a review and final decision by the superior. The process described in the problem is nothing but gamesmanship.

Problem 7-17A

a.

|Sales Budget |January |February |March |Total | |

| | | | | | |

b. Sales revenue for the quarter is equal to the sum of the monthly amounts ($240,000 + $252,000 + $264,600 = $756,600).

|c. | | | | |

|Schedule of Cash Receipts |January |February |March | |

|Receipts from January sales |$168,000 | | | |

|Receipts from January sales | |$ 48,000 | | |

|Receipts from January sales | | |$ 24,000 | |

|Receipts from February sales | |176,400 | | |

|Receipts from February sales | | |50,400 | |

|Receipts from March sales | | |185,220 | |

|Total |$168,000 |$224,400 |$259,620 | |

| | | | | |

d.

|Schedule of Cash Receipts |January |February |March |April |May | |

|Receipts from January sales | |$ 48,000 | | | | |

|Receipts from January sales | | |$ 24,000 | | | |

|Receipts from February sales | |176,400 | | | | |

|Receipts from February sales | | |50,400 | | | |

|Receipts from February sales | | | |$25,200 | | |

|Receipts from March sales | | |185,220 | | | |

|Receipts from March sales | | | |52,920 | | |

|Receipts from March sales | | | | |$26,460 | |

|Total |$168,000 |$224,400 |$259,620 |$78,120 |$26,460 | |

| | | | | | | |

The accounts receivable as of March 31, 2015 is equal to the amount due to be collected in April and May from the first quarter sales, $104,580 ($78,120 + $26,460).

Problem 7-18A

a.

|Inventory Purchases Budget |April |May |June | |

|Budgeted cost of goods sold |$75,000 |$68,000 |$60,000 | |

|Plus desired ending inventory |6,800 |6,000 |9,000 | |

|Inventory needed |81,800 |74,000 |69,000 | |

|Less beginning inventory |3,600 |6,800 |6,000 | |

|Required purchases (on account) |$78,200 |$67,200 |$63,000 | |

| | | | | |

b. Since the quarter ends on June 30, the ending inventory for June is also the ending inventory for the quarter (i.e., $9,000).

c.

|Schedule of Cash Payments |April |May |June | |

|Payment of current accounts payable |$46,920 |$40,320 |$37,800 | |

|Payment of previous accounts payable |14,800 |31,280 |26,880 | |

|Total budgeted payments for inventory |$61,720 |$71,600 |$64,680 | |

| | | | | |

d. Since 60% of the current purchases on account are paid in cash during the month of purchase, 40% will remain payable at the end of the month (i.e., $63,000 x .40 = $25,200).

Problem 7-19A

a.

|Schedule of Cash Payments for S&A Expenses | | |

| |July |August |September | |

|Salary expense |$24,000 |$24,000 |$24,000 | |

|Prior month's sales commissions, 100% |0 |2,000 |2,000 | |

|Supplies expense |360 |390 |420 | |

|Prior month's utilities, 100% |0 |1,100 |1,100 | |

|Rent |6,600 |6,600 |6,600 | |

|Miscellaneous |690 |690 |690 | |

|Total payments for S&A expenses |$31,650 |$34,780 |$34,810 | |

|Depreciation is a noncash charge. | | | | |

b. Since utilities are paid in the month following the month they are incurred, the amount payable at the end of September will be the amount of utilities expense incurred in September which is $1,100.

c. Since sales commissions are paid in the month following the month they are incurred, the amount payable at the end of September will be the amount of sales commissions expense incurred in September which is $2,000.

Problem 7-20A

This is a typical problem for what-if analysis. Students can use a computerized spreadsheet to try different possible scenarios.

a.

The budgeted net income for the next year: $580,000x115%= $667,000

Assume x = Desired sales

Sales – Cost of goods sold – S&A = NI

X – 0.7 X – ($60,000 + .10 X) = $667,000

.20 X – $60,000 = $667,000

X = $3,635,000

Alternatively, you can use the contribution margin ratio to determine sales.

Contribution margin ratio = Sales (100%) – Variable costs (80%) = 20%

(Net income + Fixed cost) ( CM ratio

= ($667,000+$60,000) ( 20% = $3,635,000

|Pro Forma Income Statement | |

|Sales revenue |$3,635,000 |

|Cost of goods sold |2,544,500 |

|Gross profit |1,090,500 |

|Selling & admin. expenses | 423,500* |

|Net income |$ 667,000 |

| | |

*($3,635,000 x 10% + $60,000) = $423,500

% increase required: ($3,635,000 – $3,200,000) ÷ $3,200,000 = 13.59% (rounded)

Problem 7-20A (continued)

b.

Budgeted cost of goods sold with a 2% cut: $2,240,000 x 98% = $2,195,200

Budgeted gross profit: $3,200,000 – $2,195,200= $1,004,800

The budgeted level of selling and administrative expenses:

$1,004,800– $667,000 = $337,800

|Pro Forma Income Statement | |

|Sales revenue |$3,200,000 |

|Cost of goods sold |2,195,200 |

|Gross profit |1,004,800 |

|Selling & admin. expenses |337,800* |

|Net income |$ 667,000 |

| | |

*The figure means that management has to cut the selling and administrative expenses by $42,200 ($380,000 – $337,800) in order to reach the president’s goal.

c.

Projected sales revenue to increase by 15%:

$3,200,000 x 115%= $3,680,000

Projected cost of goods sold: $3,680,000 x 70% = $2,576,000

|Pro Forma Income Statement | |

|Sales revenue |$3,680,000 |

|Cost of goods sold |2,576,000 |

|Gross profit |1,104,000 |

|Selling & admin. expenses |460,000 |

|Net income |$ 644,000 |

| | |

Since the projected net income under the given scenario will be only $644,000, which is short of the original $667,000, the company cannot reach its goal.

Problem 7-21A

|Cash Budget |January |February |March | |

|Beginning cash balance |$ 8,000 |$ 5,600 |$ 5,000 | |

|Add cash receipts |120,000 |116,000 |136,000 | |

|Cash available (a) |128,000 |121,600 |141,000 | |

|Less cash payments | | | | |

| For inventory purchases |110,000 |82,000 |95,000 | |

| For S&A expenses |31,000 |32,000 |27,000 | |

| Interest exp at 1% per month |4001 |5902 |5703 | |

|Total budgeted payments (b) |141,400 |114,590 |122,570 | |

|Payments minus receipts | | | | |

| Surplus (Shortage) (a – b) |(13,400) |7,010 |18,430 | |

|Financing Activity | | | | |

| Borrowing (repayment) (c) |19,000 |(2,010) |(13,430) | |

|Ending cash balance (a – b + c) |$ 5,600 |$ 5,000 |$ 5,000 | |

| | | | | |

1($40,000) x 1% = $400

2($40,000 + $19,000) x 1% = $590

3($40,000 + $19,000 – $2,010) x 1% = $570 (rounded).

Problem 7-22A

a.

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |Total |

|Oranges |440,000 |495,000 |627,000 |418,000 |1,980,000 |

|Total |$608,000 |$705,000 |$963,000 |$712,000 |$2,988,000 |

| | | | | | |

b. Budgeted cost of goods sold: $2,988,000 x 60% = $1,792,800

|Budgeted Annual Income Statement | |

|Sales revenue |$2,988,000 |

|Cost of goods sold |1,792,800 |

|Gross profit |1,195,200 |

|Selling & admin. expenses |700,000 |

|Net income |$ 495,200 |

| | |

c. Inventory purchases budget for peaches

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |

|Sales |$168,000 |$210,000 |$336,000 |$294,000 |

|Cost of goods sold |$100,800 |$126,000 |$201,600 |$176,400 |

|Plus: desired ending inventory |12,600 |20,160 |17,640 |20,000 |

|Inventory needed |113,400 |146,160 |219,240 |196,400 |

|Less: beginning inventory |10,080 |12,600 |20,160 |17,640 |

|Required purchases |$103,320 |$133,560 |$199,080 |$178,760 |

| | | | | |

Inventory purchases budget for oranges

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |

|Sales |$440,000 |$495,000 |$627,000 |$418,000 |

|Cost of goods sold |$264,000 |$297,000 |$376,200 |$250,800 |

|Plus: desired ending inventory |29,700 |37,620 |25,080 |40,000 |

|Inventory needed |293,700 |334,620 |401,280 |290,800 |

|Less: beginning inventory |26,400 |29,700 |37,620 |25,080 |

|Required purchases |$267,300 |$304,920 |$363,660 |$265,720 |

| | | | | |

Problem 7-23A

(Note: All computations are rounded to the nearest whole dollar.)

a. & b.

|Sales Budget | | | |Pro Forma |

| |Oct. |Nov. |Dec. |Data |

|Cash sales |$100,000 |$108,000 |$116,640 | |

|Sales on account |150,000 |162,000 |174,960 |$174,960(a) |

|Total budgeted sales |$250,000 |$270,000 |$291,600 |811,600(b) |

| | | | | |

|Schedule of Cash Receipts |Oct. |Nov. |Dec. | |

|Current cash sales |$100,000 |$108,000 |$116,640 | |

|Plus collections from A/R |0 |150,000 |162,000 | |

|Total collections |$100,000 |$258,000 |$278,640 |$636,640 (c) |

|(a) Ending accounts receivable balance appearing on balance sheet. |

|(b) Sales revenue appearing on income statement (sum of monthly amounts). |

|(c) Cash receipts from customers on statement of cash flows (sum of monthly amounts). |

| | | | | |

c. and d.

|Inventory Purchases Budget |

| | | | |Pro Forma |

| |Oct. |Nov. |Dec. |Data |

|Budgeted cost of goods sold |$150,000 |$162,000 |$174,960 |$486,960(a) |

|Plus: Desired ending inventory |16,200 |17,496 |12,000 |12,000(b) |

|Inventory needed |166,200 |179,496 |186,960 | |

|Less: Beginning inventory |0 |16,200 |17,496 | |

|Required purchases (on account) |$166,200 |$163,296 |$169,464 |50,839(c) |

| | | | | |

|Schedule of Cash Payments Budget for Inventory Purchases |

|Pmt. of current month's accts. pay. |$116,340 |$114,307* |$118,625* | |

|Pmt. for prior month's accts. pay. |0 |49,860 |48,989* | |

|Total budgeted pmts. for inventory |$116,340 |$164,167 |$167,614 |$448,121(d) |

| | | | | |

|(a) Cost of goods sold appearing on pro forma income statement (sum of monthly amounts). |

|(b) Ending inventory balance appearing on pro forma balance sheet. |

|(c) Ending accounts payable balance appearing on pro forma balance sheet ($169,464 - $118,625). |

|(d) Cash payments for inventory purchases (sum of monthly amounts). |

|*Rounded |

Problem 7-23A (continued)

e. and f.

|Selling and Administrative Expense Budget |

| | | | |Pro Forma |

| |Oct. |Nov. |Dec. |Data |

|Salary expense |$18,000 |$18,000 |$18,000 | |

|Sales commissions, 5% of sales |12,500 |13,500 |14,580 |$14,580(a) |

|Supplies expense, 2% of sales |5,000 |5,400 |5,832 | |

|Utilities |1,400 |1,400 |1,400 |1,400(b) |

|Depreciation on store fixtures |4,000 |4,000 |4,000 |12,000(c) |

|Rent |4,800 |4,800 |4,800 | |

|Miscellaneous |1,200 |1,200 |1,200 | |

|Total S&A expenses |$46,900 |$48,300 |$49,812 |145,012(d) |

| |

|Schedule of Cash Payments for S&A Expenses |

|Salary expense |$18,000 |$18,000 |$18,000 | |

|Prior month's sales comm., 100% |0 |12,500 |13,500 | |

|Supplies expense |5,000 |5,400 |5,832 | |

|Prior month's utilities, 100% |0 |1,400 |1,400 | |

|Depreciation on store fixtures |0 |0 |0 | |

|Rent |4,800 |4,800 |4,800 | |

|Miscellaneous |1,200 |1,200 |1,200 | |

|Total payments for S&A expenses |$29,000 |$43,300 |$44,732 |$117,032 (e) |

|Depreciation is a noncash charge. | | | | |

|(a) Ending sales commissions payable account balance shown on pro forma balance sheet. |

|(b) Ending utilities payable account balance shown on pro forma balance sheet. |

|(c) Accumulated depreciation appears on the pro forma balance sheet (sum of monthly amounts). |

|(d) S&A expense appearing on pro forma income statement (sum of monthly amounts). |

|(e) Total cash payments for S&A expenses on pro forma statement of cash flows (sum of monthly amounts). |

Problem 7-23A (continued)

g.

|Cash Budget | | | | |

| | | | |Pro Forma |

| |Oct. |Nov. |Dec. |Data |

|Beginning cash balance |$ 0 |$ 12,660 |$ 12,000 | |

|Add cash receipts |100,000 |258,000 |278,640 |$636,640(a) |

|Cash available (w) |100,000 |270,660 |290,640 | |

|Less payments | | | | |

| For inventory purchases |116,340 |164,167 |167,614 |$448,121(b) |

| For S&A expenses |29,000 |43,300 |44,732 |117,032(c) |

| Purchase of store fixtures |164,000 |0 |0 |164,000(d) |

| Interest expense* |0 |2,220 |1,730* |3,950 (f) |

|Total budgeted payments (x) |309,340 |209,687 |214,076 | |

|Payments minus receipts | | | | |

| Surplus (shortage) (w – x) |(209,340) |60,973 |76,564 | |

|Financing activity | | | | |

| Borrowing (repayment) (y) |222,000 |(48,973) |(64,564) |108,463(e) |

|Ending cash balance (w – x+ y) |$ 12,660 |$ 12,000 |$ 12,000 |12,000(g) |

| | | | | |

|*October ($0 x 0.01); November ( $222,000 x 0.01); December [( $222,000 – $48,973) x 0.01] |

|(a) Operating activities section of pro forma Statement of Cash Flows (sum of monthly amounts). |

|(b) Operating activities section of pro forma Statement of Cash Flows (sum of monthly amounts). |

|(c) Operating activities section of pro forma Statement of Cash Flows (sum of monthly amounts). |

|(d) Investing activities section of pro forma Statement of Cash Flows. The investment in store fixtures also appears on the pro forma balance sheet. |

|(e) Financing activities section of pro forma Statement of Cash Flows (sum of monthly amounts). |

|(f) Operating activities section of pro forma Statement of Cash Flows (sum of monthly amounts). |

|(g) The ending cash balance appears on the pro forma balance sheet and as the last item on the pro forma statement of cash flows. |

Problem 7-23A (continued)

h.

|Haas Company |

|Pro Forma Income Statement |

|For the Quarter Ended December 31, 2015 |

|Sales revenue | $811,600 | |

|Cost of goods sold |(486,960) | |

|Gross margin |324,640 | |

|S&A expenses |(145,012) | |

|Operating income |179,628 | |

|Interest expense |(3,950) | |

|Net income | $175,678 | |

| | | |

i.

|Haas Company |

|Pro Forma Balance Sheet |

|December 31, 2015 |

|Assets | | | |

| Cash | |$ 12,000 | |

| Accounts receivable | |174,960 | |

| Inventory | |12,000 | |

| Store fixtures |$164,000 | | |

| Accumulated depreciation |(12,000) | | |

| Book value of fixtures | |152,000 | |

|Total assets | |$350,960 | |

| | | | |

|Liabilities | | | |

| Accounts payable | |$ 50,839 | |

| Utilities payable | |1,400 | |

| Sales commissions payable | |14,580 | |

| Line of credit liability | |108,463 | |

|Equity | | | |

| Retained earnings | |175,678 | |

|Total liabilities and equity | |$350,960 | |

| | | | |

Problem 7-23A (continued)

j.

|Haas Company |

|Pro Forma Statement of Cash Flows |

|For the Quarter Ended December 31, 2015 |

| | | | |

|Cash flows from operating activities | | | |

| Cash receipts from customers |$ 636,640 | | |

| Cash payments for inventory |(448,121) | | |

| Cash payments for S&A expenses |(117,032) | | |

| Cash payments for interest expense |(3,950) | | |

|Net cash flows from operating activities | |$ 67,537 | |

| | | | |

|Cash flows from investing activities | | | |

| Cash payment for store fixtures | |(164,000) | |

| | | | |

|Cash flow from financing activities | | | |

| Net Inflow from line of credit | |108,463 | |

|Net increase in cash | |12,000 | |

|Plus: Beginning cash balance | |0 | |

|Ending cash balance | |$ 12,000 | |

| | | | |

Exercise 7-1B

The primary deficiencies in Kasey’s budgeting process are the absence of leadership and top management participation and the failure of the controller and department managers to coordinate their efforts. As a result of these flaws, department managers proposed budgets that would satisfy their individual needs at the expense of the company’s best interests.

Ms. Kasey should have established general corporate goals early in the budgeting process. She needn’t dictate company goals based on her personal ambitions; rather, she could have created a high-level committee to evaluate the company’s long-term competitive position in the market and to advise her regarding possible alternative future company goals. Once top management establishes company goals, individual departments should propose department-level goals and budgets to support the company’s general goals.

Mr. Andry should have coordinated the budgeting process among the different departments to ensure that they would propose individual budgets in support of the company’s overall goals.

Exercise 7-2B

a.

|Revenues Budget |July |August |September | |

|Food sales |$50,000 |$52,000 |$54,080 | |

|Beverage and liquor sales |30,000 |31,200 |32,448 | |

|Total budgeted revenues |$80,000 |$83,200 |$86,528 | |

| | | | | |

b. The total revenue Francis’ will report on the 3rd quarter pro forma income statement is the sum of the monthly amounts, $80,000 + $83,200 + $86,528 = $249,728.

Exercise 7-3B

a.

|Schedule of Cash Receipts |April |May |June | |

|Current cash sales |$200,000 |$160,000 |$180,000 | |

|Plus: Collections from accounts receivable |310,000 |480,000 |568,000 | |

|Total budgeted collections |$510,000 |$640,000 |$748,000 | |

| | | | | |

b. Since the current month’s sales on account will be collected in the following month, the amount of accounts receivable at the end of June is equal to June’s credit sales of $500,000.

Exercise 7-4B

a.

| |This Quarter |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |

|Dell |240,000 |242,400 |244,824 |247,272* |249,745* |

|Bacon |320,000 |329,600 |339,488 |349,673* |360,163* |

|Total |$760,000 |$780,000 |$800,632 |$821,918 |$843,880 |

| | | | | | |

*Rounded

b.

|Budgeted |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |Annual |

| | | | | | |

Exercise 7-5B

a. The expected cash collections in July are 50% of that month’s expected sales revenues. The computation follows:

$600,000 x 50% = $300,000

b. The expected cash collections in August are the sum of 50% of July’s expected revenues and 50% of August’s expected revenues. The computation follows:

($600,000 x 50%) + $(480,000 x 50%) = $540,000

Exercise 7-6B

Sales would likely be high in February because of Valentine’s Day sales, in May because of Mother’s Day sales, in June because of Father’s Day sales, and in December because of Christmas sales. Sales should be relatively stable in other months since birthdays and other personal events occur in a normal distribution pattern.

Exercise 7-7B

a.

|Inventory Purchases Budget | | | | |

| |January |February |March | |

|Budgeted cost of goods sold |$100,000 |$70,000 |$80,000 | |

|Plus desired ending inventory |7,000 |8,000 |7,500 | |

|Inventory needed |107,000 |78,000 |87,500 | |

|Less beginning inventory |10,000 |7,000 |8,000 | |

|Required purchases (on account) |$ 97,000 |$71,000 |$79,500 | |

| | | | | |

b. The amount of cost of goods sold reported on the first quarter income statement is the sum of the monthly amounts, $100,000 + $70,000 + $80,000 = $250,000.

c. Since the quarter ends on March 31, the ending inventory for March is also the ending inventory for the quarter, $7,500.

Exercise 7-8B

a.

|Schedule of Cash Payments for Inventory Purchases | |

| |Oct. |Nov. |Dec. | |

|Payment for current accounts payable |$42,000 |$31,500 |$56,000 | |

|Payment for previous accounts payable |15,000 |18,000 |13,500 | |

|Total budgeted payments for inventory |$57,000 |$49,500 |$69,500 | |

| | | | | |

b. Since 70% of current accounts payable are paid in cash in the month of purchase, 30% will remain payable at the end of any month,$24,000 ($80,000 x .30) at the end of December.

Exercise 7-9B

a. Budgeted cost goods sold for February is $492,000 ($480,000 x 1.025).

|Desired February ending inventory balance |$ 50,000 |

|Budgeted cost of goods sold |492,000 |

|Inventory needed in February |542,000 |

|Less: beginning inventory balance (January) |(40,000) |

|Budgeted February purchases |$502,000 |

b.

|January’s payables balance paid in February |$ 38,000 |

|Cash paid for February purchases ($502,000 x 0.60) |301,200 |

|Projected cash payments for February |$339,200 |

Exercise 7-10B

a. An inventory purchases budget prepared with Holly’s estimate:

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |

|Sales |$480,000 |$600,000 |$450,000 |$720,000 |

|Cost of goods sold |$288,000 |$360,000 |$270,000 |$432,000 |

|Plus: ending inventory |54,000 |40,500 |64,800 |50,000 |

|Inventory needed |342,000 |400,500 |334,800 |482,000 |

|Less: beginning inventory |40,000 |54,000 |40,500 |64,800 |

|Required purchases |$302,000 |$346,500 |$294,300 |$417,200 |

| | | | | |

b. An inventory purchases budget prepared with Justin's estimate:

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |

|Sales |$400,000 |$450,000 |$500,000 |$850,000 |

|Cost of goods sold |$240,000 |$270,000 |$300,000 |$510,000 |

|Plus: ending inventory |40,500 |45,000 |76,500 |50,000 |

|Inventory needed |280,500 |315,000 |376,500 |560,000 |

|Less: beginning inventory |40,000 |40,500 |45,000 |76,500 |

|Required purchases |$240,500 |$274,500 |$331,500 |$483,500 |

| | | | | |

Exercise 7-11B

a.

|Schedule of Cash Payments for Selling and Administrative Expenses | |

| |January |February |March | |

|Equipment depreciation* |$ 0 |$ 0 |$ 0 | |

|Prior month's salary expense, 100% |0 |8,000 |8,000 | |

|Cleaning supplies |1,000 |940 |1,100 | |

|Insurance premium |7,200 |0 |0 | |

|Equipment maintenance expense |500 |500 |500 | |

|Leases expense |1,600 |1,600 |1,600 | |

|Miscellaneous expenses |400 |400 |400 | |

|Total payments for S&A expenses |$10,700 |$11,440 |$11,600 | |

|*Depreciation is a noncash charge. | | | | |

b. Since salary expense is paid in the month following the month it is incurred, the amount payable at the end of March will be the amount of salary expense incurred in March, $7,200.

c. Since the annual insurance premium is prepaid on January 1, the amount of prepaid insurance at the end of March will be $5,400 [$7,200 – ($600 x 3)].

Exercise 7-12B

|a. Budgeted payments for January: | |

| Office lease |$ 5,400 |

| Utilities |1,600 |

|Office supplies |3,000 |

| Miscellaneous |1,000 |

| Total* |$11,000 |

*The referral fees are not included because cash payment for them will be made in February. The depreciation is not included because depreciation does not require a cash payment. Cash for depreciable assets is paid when the assets are purchased rather than when depreciation is recognized.

b. The full $5,000 balance for the referral fees will remain payable at the end of January.

c. Since the office lease is $5,400 each month, the annual lease expense will be $64,800 ($5,400 x 12).

Exercise 7-13B

a.

|Cash Budget |July |August |September | |

|Beginning cash balance |$ 20,000 |$ 4,000 |$ 4,000 | |

|Add cash receipts |180,000 |192,000 |208,000 | |

|Cash available (a) |200,000 |196,000 |212,000 | |

|Less disbursements | | | | |

| For inventory purchases |162,000 |153,000 |171,000 | |

| For S&A expenses |37,000 |36,000 |39,000 | |

| Interest expenses at 1% per month |0 |301 |0 | |

|Total budgeted disbursements (b) |199,000 |189,030 |210,000 | |

|Cash surplus (shortage) (a – b) |1,000 |6,970 |2,000 | |

|Financing activity | | | | |

| Borrowing (repayment) (c) |3,000 |(2,970) |2,000 | |

|Ending cash balance (a – b + c) |$ 4,000 |$ 4,000 |$ 4,000 | |

| | | | | |

1$3,000 x 1% = $30

2($3,000 – $2,970) x 1% = $0 (rounded)

b. Net cash flows from operating activities equals total (sum of the monthly amounts) cash receipts from customers minus total (sum of the monthly amounts) cash payments for inventory, S&A expenses, and interest. The computation follows:

($180,000 + $192,000 + $208,000) – ($199,000 + $189,030 + $210,000)

= $580,000 – $598,030

= $(18,030) net cash outflow

c. Net cash flows from financing activities is the amount borrowed less repayments. The computation follows:

$3,000 – $2,970 + $2,000 = $2,030 net cash inflow

Exercise 7-14B

a.

|Cash Collections | | |

| Collections from June 30 receivables balance |$ 60,000 | |

| Collections from July’s credit sales ($360,000 x 0.75) |270,000 | |

| July cash sales |85,000 | |

| Total cash receipts in July | |$415,000 |

|Desired cash balance |20,000 | |

|Cash disbursements in July |420,000 | |

|Total July cash needs | |440,000 |

|Cash shortage (amount to borrow) | |$ 25,000 |

b. There will be no interest reported on the July pro forma income statement because the money was borrowed on the last date of the month.

c. Estimated interest expense for August is $250 [$25,000 x (12% ( 12)].

Exercise 7-15B

a. Pro forma income statement prepared with Mr. Souta’s estimate:

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |Total |

|Cost of goods sold |252,000 |210,000 |226,800 |329,700 |1,018,500 |

|Gross margin |252,000 |210,000 |226,800 |329,700 |1,018,500 |

|S&A expenses |63,000 |52,500 |56,700 |82,425 |254,625 |

|Net income |$189,000 |$157,500 |$170,100 |$247,275 |$ 763,875 |

| | | | | | |

b. Pro forma income statement prepared with Ms. Case’s estimate:

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |Total |

|Cost of goods sold |259,200 |216,000 |233,280 |339,120 |1,047,600 |

|Gross margin |259,200 |216,000 |233,280 |339,120 |1,047,600 |

|S&A expenses |64,800 |54,000 |58,320 |84,780 |261,900 |

|Net income |$194,400 |$162,000 |$174,960 |$254,340 | $ 785,700 |

| | | | | | |

Exercise 7-15B (continued)

c. Forecasting is not likely to be 100% accurate. It is based on inexact factors such as judgment and economic predictions. Different executive officers in the same company will probably have different future expectations. In addition to legitimate differences of opinion, self-interest may also contribute to disagreement. For example, Mikhail Souta, who deals with customers’ credit problems and uncollectible accounts, may want stricter criteria for granting customer credit, which would naturally result in lower sales growth. On the other hand, Lillian Case, who deals with market potential and sales commissions, may want looser criteria for customer credit, which would result in greater sales growth.

Problem 7-16B

a. Pro forma income statement assuming 4% growth:

| |Budget |

|Sales revenue |$6,240,000 |

|Cost of goods sold |3,744,000 |

|Gross profit |2,496,000 |

|Selling & administrative expenses |998,400 |

|Net income |$1,497,600 |

| | |

b. Pro forma income statement assuming 8% rate:

| |Budget |

|Sales revenue |$6,480,000 |

|Cost of goods sold |3,888,000 |

|Gross profit |2,592,000 |

|Selling & administrative expenses |1,036,800 |

|Net income |$1,555,200 |

| | |

c. Excess of actual net income over budget:

$1,555,200 – $1,497,600 = $57,600

Bonus: $57,600 x 10% = $5,760

Problem 7-16B (continued)

d. The process of participative budgeting is recommended. This process requires two-way communication between the president and divisional directors. Any disagreement on budget assumptions should be fully discussed with pros and cons being well considered. If the president believes that the divisional budget is unrealistic, he/she should tell the vice president directly and explain the reasons. Participative budgeting is more than just a submission of a budget proposal from a subordinate and a review and final decision by the superior. The process described in the problem is nothing but gamesmanship.

It would be unethical if Ms. West proposes only a 4% growth rate because it not only reflects a dishonest estimate but also results in Ms. West’s personal gain at the expense of her employer. On the other hand, the company's plan to use the excess of actual income over budget as the basis for bonuses is an invitation for unethical behavior.

Problem 7-17B

a.

|Sales Budget |January |February |Total | |

|Sales on account |$720,000 |$792,000 |$1,512,000 | |

| | | | | |

b. Sales revenue for January and February is equal to the sum of the monthly amounts ($720,000 + $792,000 = $1,512,000).

|c. | | |

|Schedule of Cash Receipts |January |February |

|Receipts from December sales |$120,000 | |

|Receipts from January sales |576,000 | |

|Receipts from January sales | |$144,000 |

|Receipts from February sales | |633,600 |

|Receipts from February sales | | |

|Total |$696,000 |$777,600 |

| | | |

d. The accounts receivable as of February 28, 2015 is equal to the amount due to be collected in March, $158,400 ($792,000 x 20%).

Problem 7-18B

a.

|Inventory Purchases Budget |Oct. |Nov. |Dec. | |

|Budgeted cost of goods sold |$360,000 |$450,000 |$540,000 | |

|Plus desired ending inventory |90,000 |108,000 |96,000* | |

|Inventory needed |450,000 |558,000 |636,000 | |

|Less beginning inventory |80,000 |90,000 |108,000 | |

|Required purchases (on account) |$370,000 |$468,000 |$528,000 | |

| | | | | |

*$640,000 x .75 x .20 = 96,000

b. Since the quarter ends on December 31, the ending inventory for December is also the ending inventory for the quarter (i.e., $108,000).

c.

|Schedule of Cash Payments |Oct. |Nov. |Dec. | |

|Payment of current accounts payable |$259,000 |$327,600 |$369,600 | |

|Payment of previous accounts payable |75,000 |111,000 |140,400 | |

|Total budgeted payments for inventory |$334,000 |$438,600 |$510,000 | |

| | | | | |

d. Since the quarter ends on December 31, the ending accounts payable balance for December is the balance in accounts payable that will appear on the end of quarter pro forma balance sheet. 70% of the current purchases on account are paid in cash during the month of purchase, therefore, 30% will remain payable at the end of the month (i.e., $528,000 x .30 = $158,400).

Problem 7-19B

a.

|Schedule of Cash Payments for S&A Expenses | | |

| |January |February |March | |

|Salary expense |$12,000 |$12,000 |$12,000 | |

|Prior month's sales commissions |0 |900 |600 | |

|Prior month's advertising expense |0 |500 |500 | |

|Prior month's telephone expense |0 |1,000 |1,080 | |

|Rent |10,000 |10,000 |10,000 | |

|Miscellaneous |800 |800 |800 | |

|Total payments for S&A expenses |$22,800 |$25,200 |$24,980 | |

|Depreciation is a noncash charge. | | | | |

b. Since telephone expense is paid in the month following the month it is incurred, the amount payable at the end of March will be the amount of telephone expense incurred in March, $1,100.

c. Since sales commissions are paid in the month following the month they are incurred, the amount payable at the end of February will be the amount of sales commissions expense incurred in February, $600.

Problem 7-19B

This is a typical problem for what-if analysis. Students can use a computerized spreadsheet to try different possible scenarios.

Budgeted net income for the next year: $110,000 x 120%= $132,000

Budgeted cost of goods sold for the next year:

$560,000 ÷ $800,000 = 70% of sales

Budgeted selling and administrative expenses for the next year:

$78,000 +10% of sales.

a. The budgeted sales that meet the goal:

If sales = X

Sales – Cost of goods sold – S&A expenses = NI

1X – .70X – ($78,000 + .10X) = $132,000

.20X – $78,000 = $132,000

.20X = $210,000

X = $1,050,000

($1,050,000 – $800,000) ÷ $800,000 = 31.25% increase in sales

|Pro Forma Income Statement | |

|Sales revenue |$1,050,000 |

|Cost of goods sold |735,000 |

|Gross profit |315,000 |

|Selling & admin. expenses |183,000* |

|Net income |$ 132,000 |

| | |

*($1,050,000 x 10% + $78,000) = $183,000

b.

Budgeted cost of goods sold with a 3% cut:

$560,000 x 97% = $543,200

Budgeted gross profit: $800,000 – $543,200= $256,800

The budgeted level of selling and administrative expenses:

If X = S&A expenses

Gross Profit – X = $132,000

$256, 800 – X = $132,000

X = $124,800

Problem 7-20B (continued)

|Pro Forma Income Statement | |

|Sales revenue |$800,000 |

|Cost of goods sold |543,200 |

|Gross profit |256,800 |

|Selling & admin. expenses |124,800* |

|Net income |$132,000 |

| | |

*The figure means that management has to cut the selling and administrative expenses by $5,200 in order to reach Mr. Hearn’s goal.

c.

Projected sales revenue to increase by 25%:

$800,000 x 125%= $1,000,000

Projected cost of goods sold: $1,000,000 x 70% = $700,000

|Pro Forma Income Statement | |

|Sales revenue |$1,000,000 |

|Cost of goods sold |700,000 |

|Gross profit |300,000 |

|Selling & admin. expenses |170,000 |

|Net income |$130,000 |

| | |

Since the projected net income under the given scenario will be $130,000, which is still a little bit short of the desired $132,000, the company cannot reach its goal.

Problem 7-21B

|Cash Budget |April |May |June | |

|Beginning cash balance |$ 36,000 |$ 60,000 |$ 60,290 | |

|Add cash receipts |400,000 |440,000 |660,000 | |

|Cash available (a) |436,000 |500,000 |720,290 | |

|Less cash payments | | | | |

| For inventory purchases |410,000 |420,000 |464,000 | |

| For S&A expenses |80,000 |106,000 |132,000 | |

| Interest exp at 1% per month |01 |1,7102 | 3,0303 | |

|Total budgeted payments (b) |490,000 |527,710 |599,030 | |

|Payments minus receipts | | | | |

| Surplus (shortage) (a–b) |(54,000) |(27,710) |121,260 | |

|Financing Activity | | | | |

| Borrowing (repayment) (c) |114,000 |88,000 |(61,260) | |

| | | | | |

|Ending cash balance (a – b + c) |$ 60,000 |$ 60,290 |$ 60,000 | |

| | | | | |

1$0 x 1.5% = $0

2114,000 x 1.5% = $1,710

3($114,000 + $88,000) x 1.5% = $3,030

Problem 7-22B

When necessary, all computations are rounded to the nearest dollar.

a.

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |Total |

|Calculator |260,000 |286,000 | 301,600 |338,000 |1,185,600 |

|Total |$920,000 |$1,001,000 |$1,093,600 |$1,251,000 |$4,265,600 |

| | | | | | |

Problem 7-22B (continued)

b. Budgeted cost of goods sold: $4,265,600 x 75% = $3,199,200

|Budgeted Annual Income Statement | |

|Sales revenue |$4,265,600 |

|Cost of goods sold |3,199,200 |

|Gross profit |1,066,400 |

|Selling & admin. expenses |500,000 |

|Net income |$ 566,400 |

| | |

c. Inventory purchases budget for palm-size computers:

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |

|Sales |$660,000 |$ 715,000 |$ 792,000 |$ 913,000 |

|Cost of goods sold |$495,000 |$536,250 |$594,000 |$684,750 |

|Plus: desired ending inventory |53,625 |59,400 |68,475 |78,000 |

|Inventory needed |548,625 |595,650 |662,475 |762,750 |

|Less: beginning inventory |68,000 |53,625 |59,400 |68,475 |

|Required purchases |$480,625 |$542,025 |$603,075 |$694,275 |

| | | | | |

Inventory purchases budget for programmable calculators:

| |1st Quarter |2nd Quarter |3rd Quarter |4th Quarter |

|Sales |$260,000 |$286,000 | $301,600 |$338,000 |

|Cost of goods sold |$195,000 |$214,500 |$226,200 |$253,500 |

|Plus: desired ending inventory |21,450 |22,620 |25,350 |42,000 |

|Inventory needed |216,450 |237,120 |251,550 |295,500 |

|Less: beginning inventory |32,000 |21,450 |22,620 |25,350 |

|Required purchases |$184,450 |$215,670 |$228,930 |$270,150 |

| | | | | |

Problem 7-23B (Note: All computations are rounded to the nearest whole dollar.)

a. & b.

|Sales Budget | | | | |

| | | | |Pro Forma |

| |January |February |March |Data |

|Cash sales |$ 75,000 |$ 82,500 |$ 90,750 | |

|Sales on account |175,000 |192,500 |211,750 |$211,750(a) |

|Total budgeted sales |$250,000 |$275,000 |$302,500 |827,500(b) |

| | | | | |

|Schedule of Cash Receipts | | | |Pro Forma |

| |January |February |March |Data |

|Current cash sales |$ 75,000 |$ 82,500 |$ 90,750 | |

|Plus: Collections from accts. rec. |0 |175,000 |192,500 | |

|Total collections |$75,000 |$257,500 |$283,250 |$615,750 (c) |

|(a) Ending accounts receivable balance appearing on balance sheet. |

|(b) Sales revenue appearing on income statement (sum of monthly amounts). |

|(c) Cash receipts from customers on statement of cash flows (sum of monthly amounts). |

| | | | | |

c. and d.

|Inventory Purchases Budget |

| | | | |Pro Forma |

| |Jan. |Feb. |Mar. |Data |

|Budgeted cost of goods sold |$125,000 |$137,500 |$151,250 |$413,750(a) |

|Plus desired ending inventory |27,500 |30,250 |33,000 |33,000(b) |

|Inventory needed |152,500 |167,750 |184,250 | |

|Less beginning inventory |0 |27,500 |30,250 | |

|Required purchases (on Acct.) |$152,500 |$140,250 |$154,000 |61,600(c) |

| | | | | |

|Schedule of Cash Payments Budget for Inventory Purchases | Pro Forma |

| |January |February |March |Data |

|Pmt of current month's A/P |$91,500 |$ 84,150 |$ 92,400 | |

|Pmt for prior month's A/P |0 |61,000 |56,100 | |

|Total budgeted pmts. for invent. |$91,500 |$145,150 |$148,500 |$385,150(d) |

| | | | | |

|(a) Cost of goods sold appearing on pro forma income statement (sum of monthly amounts). |

|(b) Ending inventory balance appearing on pro forma balance sheet. |

|(c) Ending accounts payable balance appearing on pro forma balance sheet ($154,000 x 0 .40). |

|(d) Cash payments for inventory purchases on statement of cash flows (sum of monthly amounts). |

Problem 7-23B (continued)

e. and f.

|Selling and Administrative Expense Budget |

| | | | |Pro Forma |

| |January |February |March |Data |

|Salary expense |$25,000 |$25,000 |$25,000 | |

|Sales commissions, 8% sales |20,000 |22,000 |24,200 |$24,200(a) |

|Supplies expense, 4% sales |10,000 |11,000 |12,100 | |

|Utilities |1,800 |1,800 |1,800 |1,800(b) |

|Depreciation on store fixtures |5,000 |5,000 |5,000 |15,000(c) |

|Rent |7,200 |7,200 |7,200 | |

|Miscellaneous |2,000 |2,000 |2,000 | |

|Total S&A expenses |$71,000 |$74,000 |$77,300 |222,300(d) |

| |

|Schedule of Cash Payments for S&A Expenses |

|Salary expense |$25,000 |$25,000 |$25,000 | |

|Prior month's sales comm., 100% |0 |20,000 |22,000 | |

|Supplies expense |10,000 |11,000 |12,100 | |

|100% prior month's utilities, 100% |0 |1,800 |1,800 | |

|Depreciation on store fixtures |0 |0 |0 | |

|Rent |7,200 |7,200 |7,200 | |

|Miscellaneous |2,000 |2,000 |2,000 | |

|Total payments for S&A expenses |$44,200 |$67,000 |$70,100 |$181,300(e) |

|Depreciation is a noncash charge. | | | | |

|(a) Ending sales commissions payable account balance shown on pro forma balance sheet. |

|(b) Ending utilities payable account balance shown on pro forma balance sheet. |

|(c) Accumulated depreciation appears on the pro forma balance sheet (sum of monthly amounts). |

|(d) Total S&A expenses appearing on pro forma income statement (sum of monthly amounts). |

|(e) Total cash payments for S&A expenses on pro forma statement of cash flows (sum of monthly amounts). |

Problem 7-23B (continued)

g.

|Cash Budget | | | | |

| | | | |Pro Forma |

| |January |February |March |Data |

|Beginning cash balance |$ 0 |$ 50,300 |$ 50,000 | |

|Add cash receipts |75,000 |257,500 |283,250 |$615,750(a) |

|Cash available (w) |75,000 |307,800 |333,250 | |

|Less payments | | | | |

| For inventory purchases |91,500 |145,150 |148,500 |385,150(b) |

| For S&A expenses |44,200 |67,000 |70,100 |181,300(c) |

| Purchase of store fixtures |350,000 |0 |0 |350,000(d) |

| Interest expense* |0 |6,915 |6,334 |13,249(f) |

|Total budgeted payments (x) |485,700 |219,065 |224,934 | |

|Payments minus receipts | | | | |

| Surplus (shortage) (w – x) |(410,700) |88,735 |108,316 | |

|Financing activity | | | | |

| Borrowing (repayment) (y) |461,000 |(38,735) |(58,316) |363,949(e) |

|Ending cash balance (w – x + y) |$ 50,300 |$ 50,000 |$50,000 |50,000(g) |

| | | | | |

|*January ($0 x 0.015); February ($461,000 x 0.015); March [($461,000 – $38,735) x 0.015] |

|(a) Operating activities section of pro forma statement of cash flows (sum of monthly amounts). |

|(b) Operating activities section of pro forma statement of cash flows (sum of monthly amounts). |

|(c) Operating activities section of pro forma statement of cash flows (sum of monthly amounts). |

|(d) Investing activities section of pro forma statement of cash flows. The investment in store fixtures also appears on the pro forma balance |

|sheet. |

|(e) Financing activities section of pro forma statement of cash flows (sum of monthly amounts). |

|(f) Operating activities section of pro forma statement of cash flows (sum of monthly amounts). |

|(g) The ending cash balance appears on the pro forma balance sheet and as the last item on the statement of cash flows. |

Problem 7-23B (continued)

h.

|Peters Gifts Corporation |

|Pro Forma Income Statement |

|For the Quarter Ended March 31, 2014 |

|Sales revenue | $827,500 | |

|Cost of goods sold |(413,750) | |

|Gross margin |413,750 | |

|S&A expenses |(222,300) | |

|Operating income |191,450 | |

|Interest expense |(13,249) | |

|Net income | $178,201 | |

| | | |

i.

|Peters Gifts Corporation |

|Pro Forma Balance Sheet |

|March 31, 2014 |

|Assets | | | |

| Cash | |$ 50,000 | |

| Accounts receivable | |211,750 | |

| Inventory | |33,000 | |

| Store fixtures |$350,000 | | |

| Accumulated depreciation |(15,000) | | |

| Book Value of fixtures | |335,000 | |

|Total assets | |$629,750 | |

| | | | |

|Liabilities | | | |

| Accounts payable | |$ 61,600 | |

| Sales commissions payable | |24,200 | |

| Utilities payable | |1,800 | |

| Line of credit liability | |363,949 | |

|Equity | | | |

| Retained earnings | |178,201 | |

|Total liabilities and equity | |$629,750 | |

| | | | |

Problem 7-23B (continued)

j.

|Peters Gifts Corporation |

|Pro Forma Statement of Cash Flows |

|For the Quarter Ended March 31, 2014 |

| | | | |

|Cash flows from operating activities | | | |

| Cash receipts from customers |$615,750 | | |

| Cash payments for inventory |(385,150) | | |

| Cash payments for S&A expenses |(181,300) | | |

| Cash payments for interest expense |(13,249) | | |

|Net cash flows from operating activities | |$ 36,051 | |

| | | | |

|Cash flows from investing activities | | | |

| Cash payment for store fixtures | |(350,000) | |

| | | | |

|Cash flows from financing activities | | | |

| Net inflow from line-of-credit | |363,949 | |

|Net increase in cash | |50,000 | |

|Plus beginning cash balance | |0 | |

|Ending cash balance | |$ 50,000 | |

| | | | |

ATC 7-1

a.

|Budgeted | | |

|Financial Statements | | |

|Income Statement |Amounts |Computations |

|Sales Revenue |$300,000 | 12 x $25,000 |

|Cost of Goods Sold |(264,000) | 12 x $22,000 |

|Depreciation Expense |(3,000) | ($18,000 – $6,000) ÷ 4 |

|Other Expense |(4,000) | $22,000 – $18,000 |

|Operating Income |29,000 | |

|Interest Expense |(850) | $17,000 x .05 |

| Net Income |$28,150 | |

| | | |

|Statement of Cash Flows | | |

|Operating Activities: | | |

| Inflows from sales |$300,000 | 12 x $25,000 |

| Outflows for: | | |

| Purchase of food, etc. |(264,000) | 12 x $22,000 |

| Other initial expenses |(4,000) | $22,000 – $18,000 |

| Interest Expense |(850) | $17,000 x .05 |

|NCF Operating Activities |31,150 | |

| | | |

|Investing Activities: | | |

| Outflow for purchase of | | |

|cart |(18,000) |given |

| | | |

|Financing Activities” | | |

| Inflows from: | | |

| Contribution by owners |5,000 | given |

| Loan from parents |17,000 | given |

|Financing Act. |22,000 | |

|Net Change in Cash |31,150 | |

| Plus beginning cash |0 | |

|Ending cash balance |$31,150 | |

| | | |

ATC 7-1 (continued)

|Budgeted | | |

|Financial Statements | | |

|continued | | |

|Balance Sheet |Amounts |Computations |

|Cash |$31,150 | from SCF |

|Food cart |18,000 | given |

|Acc. Depreciation |(3,000) | ($18,000 – $6,000) ÷ 4 |

| Total Assets |$50,150 | |

| | | |

|Note Payable |$17,000 | given |

| | | |

|Contributed Capital |5,000 | given |

|Retained Earn. |28,150 | from Inc. Statement |

|Total Liab. & Equity |$50,150 | |

| | | |

b. The budget financial statements above assume sales for each month of the year will be approximately equal to sales for September and October. Most likely, sales will be lower during periods between semesters, during the colder months, and during the summer session. On the plus side, some of the initial expenses of $4,000 ($22,000 - $18,000) may not have to be incurred every year.

Also, the presentation above assumes the owners do not take any money out of the business. Obviously, they would need to use some of the earnings from the business to pay their living expenses.

ATC 7-2

a. Group Tasks

Task 1

| | | | |Pro Forma | |

| |October |November |December |Data | |

|Cash sales |$ 40,000 |$ 44,000 |$ 48,400 | | |

|Sales on account |140,000 |154,000 |169,400 |$169,400 |Accounts Rec. |

|Total budgeted sales |$180,000 |$198,000 |$217,800 |595,800 |Sales Rev. |

| | | | | | | |

|Schedule of Cash Receipts |

| |October |November |December |

|Cash sales |$ 40,000 |$ 44,000 |$ 48,400 |

|Collections from accounts receivable |60,000 |140,000 |154,000 |

|Total cash collections |$100,000 |$184,000 |$202,400 |

Task 2

| | | | |Pro Forma | |

| |Oct. |Nov. |Dec. |Data | |

|Budgeted cost of goods sold |$72,000 |$79,200 |$87,120 |$238,320 |Cost of Goods Sold |

|Plus: Desired ending inventory |14,400 |15,840 |17,424 |17,424 |Ending Inventory |

|Inventory needed |86,400 |95,040 |104,544 | | | |

|Less: Beginning inventory |40,000 |14,400 |15,840 | | | |

|Required purchases (on account) |$46,400 |$80,640 |$88,704 |22,176 |Accounts Payable |

|Schedule of Cash Payments Budget for Inventory Purchases |

| |October |November |December |

|Pmt of current month's accts. pay. |$34,800 |$60,480 |$66,528 |

|Pmt for prior month's accts. pay. |72,000 |11,600 |20,160 |

|Total budgeted pmts. for inventory |$106,800 |$72,080 |$86,688 |

ATC 7-2 (continued)

Task 3

| | | | |Pro Forma | |

| |Oct. |Nov. |Dec. |Data | |

|Sales commissions |$ 7,200 |$ 7,920 |$ 8,712 |$ 8,712 |Commissions pay. |

|Supplies expense |1,800 |1,980 |2,178 | | |

|Utilities |2,200 |2,200 |2,200 |2,200 |Utility payable |

|Depreciation on store equipment |1,600 |1,600 |1,600 |4,800 |Accum. dep. |

|Salary expense |34,000 |34,000 |34,000 | | |

|Rent |6,000 |6,000 |6,000 | | |

|Miscellaneous |1,000 |1,000 |1,000 | | |

|Total S&A expenses |$53,800 |$54,700 |$55,690 |$164,190 |S&A Exp. |

b. Financial Statements

|Income Statement | |

|Sales revenue |$595,800 |

|Cost of goods sold |(238,320) |

|Gross margin |357,480 |

|Operating expenses |(164,190) |

|Operating income |193,290 |

|Interest expense |(2,530) |

|Net income |$190,760 |

| | |

ATC 7-2 (continued)

|Balance Sheet | | |

|Assets | | |

| Cash | |$ 9,760 |

| Accounts receivable | |169,400 |

| Inventory | |17,424 |

| Store equipment |$200,000 | |

| Accumulated depreciation store equipment |(81,600) | |

| Book value of store equipment | |118,400 |

|Total assets | |$314,984 |

| | | |

|Liabilities | | |

| Accounts payable | |$ 22,176 |

| Utilities payable | |2,200 |

| Sales commissions payable | |8,712 |

| Line of credit | |23,936 |

|Equity | | |

| Common stock | |50,000 |

| Retained earnings | |207,960 |

|Total liabilities and equity | |$314,984 |

| | | |

c. Havel will need to borrow money in October.

|Cash Budget for October | |

| | |

|Beginning cash balance |$ 16,000 |

|Add: Cash receipts |100,000 (1) |

|Cash available |116,000 |

|Less: Payments | |

| For inventory purchases |106,800 (2) |

| For S&A expenses |42,800 (3) |

|Total budgeted payments |149,600 |

| | |

| Payments minus receipts = shortage |$ 33,600 |

ATC 7-2 (continued)

(1) $40,000 cash sales + $60,000 collection on September accounts receivable.

(2) $34,800 payment for Oct. Inventory + $72,000 payment on September accounts payable.

(3) $53,800 October S&A expenses – $7,200 sales commissions – $2,200 utilities expense – $1,600 depreciation = $42,800

ATC 7-3

a. There was a budgeted surplus in 6 years of in the 53 years from 1960 to 2011: 1960, 1969, 1998, 1999, 2000, 2001. Thus, a deficit was reported in 47 years.

b. 2009 had a deficit of 10.1 % of GDP

2010 had a deficit of 9.0 % of GDP

2011 had a deficit of 8.7 % of GDP.

c. For 2009: Deficit $1,412,688

Receipts $2,104,989

= 67.1% of expenditures were paid for with borrowed funds, 32.9 % were paid for with tax revenues.

d. The departments whose budgets changed the most from the Clinton years to the Bush years were:

Treasury 4.6 decrease

Health and Human Services 2.5 increase

Defense—Military 2.4 increase

Social Security Administration (Off-budget) 1.6 decrease

Homeland Security 0.8 increase

See the table below for complete data.

ATC 7-3 continued

|Comparison of Average Budget Percentages by Department for 1994 - 2001 (Clinton Years) to 2002 – 2009 (Bush Years) |

| |Average |Average | |

| |for |for | |

| |Clinton |Bush | |

| |Years |Years |Difference |

|Legislative Branch |0.2 |0.2 |0.0 |

|Judicial Branch |0.2 |0.2 |0.0 |

|Department of Agriculture |3.7 |3.3 |-0.4 |

|Department of Commerce |0.3 |0.3 |0.0 |

|Department of Defense--Military Programs |16.2 |18.6 |2.4 |

|Department of Education |1.9 |2.5 |0.6 |

|Department of Energy |1.0 |0.8 |-0.2 |

|Department of Health and Human Services |20.9 |23.4 |2.5 |

|Department of Homeland Security |0.7 |1.5 |0.8 |

|Department of Housing and Urban Development |1.8 |1.7 |-0.1 |

|Department of the Interior |0.4 |0.4 |-0.1 |

|Department of Justice |0.8 |1.0 |0.2 |

|Department of Labor |2.1 |2.5 |0.4 |

|Department of State |0.4 |0.5 |0.1 |

|Department of Transportation |2.3 |2.4 |0.0 |

|Department of the Treasury |22.4 |17.8 |-4.6 |

|Department of Veterans Affairs |2.5 |2.7 |0.2 |

|Corps of Engineers--Civil Works |0.2 |0.2 |0.0 |

|Other Defense Civil Programs |1.9 |1.7 |-0.2 |

|Environmental Protection Agency |0.4 |0.3 |-0.1 |

|Executive Office of the President | |0.2 |0.2 |

|General Services Administration |0.1 | |-0.1 |

|International Assistance Programs |0.6 |0.5 |-0.1 |

|National Aeronautics and Space Administration |0.9 |0.6 |-0.2 |

|National Science Foundation |0.2 |0.2 |0.0 |

|Office of Personnel Management |2.7 |2.4 |-0.4 |

|Small Business Administration |0.1 |0.1 |0.0 |

|Social Security Administration (On-Budget) |2.2 |2.1 |-0.1 |

|Social Security Administration (Off-Budget) |22.1 |20.5 |-1.6 |

|Other Independent Agencies (On-Budget) |0.3 |0.8 |0.6 |

|Other Independent Agencies (Off-Budget) |0.1 |0.0 |-0.1 |

|Allowances | | | |

|Undistributed Offsetting Receipts |-9.4 |-9.2 |0.1 |

|(On-budget) |-6.2 |-5.0 |1.2 |

|(Off-budget) |-3.2 |-4.2 |-1.0 |

|Total outlays |100.0 |100.0 |0.0 |

ATC 7-4

The memorandum written by students should identify some of the following potential challenges.

• The USOC does not have a typical twelve month business cycle like most businesses, so results from one quarter of the year, or even one whole year, may not provide much guidance regarding how to budget for the next quarter or the next year.

• Revenue and expenses vary greatly depending on whether there is an Olympic competition to be held in a given year.

• Many of the USOC’s revenues are not correlated with activities that cause it to incur expenses, as is the case with business enterprises. Thus, just because revenues are down it does not mean that expenses will also decline.

• Much of the USOC’s revenues come from private contributions, and it is difficult to forecast the many factors that can affect contributions. Some example: a weak economy may hurt contributions, even if athletes are performing well; if U.S. athletes are very successful at a given Olympics, it probably encourages contributions, and the USOC has limited control of athletic success; if there is a scandal regarding the USOC or its athletes, this may hurt contributions, even if the USOC had little ability to control the event.

• Any grants from government sources may be affected by politics.

• Games may be disrupted by international events over which the USOC has no control or event the ability to predict. These events can reduce revenue unexpectedly.

ATC 7-5

a. Mr. Cleaver’s behavior could be construed to be in violation of the objectivity standards. The failure to disclose the lack of need for computers to the Board of Education would violate (1) the standard to communicate information fairly and objectively and (2) the standard to disclose fully all relevant information that could reasonably be expected to influence an intended user’s understanding of the reports, comments, and recommendations presented. However, Mr. Cleaver could have disclosed all information fairly to the board. He is correct in his assessment that neither he nor Ms. Simmons has the right to establish policy. Also, it should be noted that Mr. Cleaver may not be a member of the Institute of Management Accountants and is therefore not bound by the organization’s code of ethics.

b. Sarbanes-Oxley Act requires management of public companies to report accurately the financial statements to external users such as investors and creditors. This case does not involve external reporting, and, consequently, the law is not applicable. However, with recent school board scandals abound in the past ten years, many principles of Sarbanes-Oxley have been adopted by school districts.

c. As its name implies, participative budgeting encourages participation by subordinates as well as upper level managers in the budget process. Information flows from the bottom up as well as from the top down during the preparation of the budget. Accordingly, the Board of Education members would be in a position to gain insight as to the true needs of the schools and would thereby be more likely to allocate funds where they would produce the greatest benefit.

ATC 7-6

Screen capture of cell values:

[pic]

ATC 7-6 (continued)

Screen capture of cell formulas:

[pic]

ATC 7-7

Screen capture of cell values:

[pic]

ATC 7-7

Screen capture of cell formulas:

[pic]

ATC 7-7

Screen capture of cell formulas (continued):

[pic]

|Chapter 7 Comprehensive Problem | | |

| | | | | |

| |Growth Rate of Sales | |0.01 | |

| |Sales Budget | | | |

| | |Jan |Feb |Mar |

| |Cash sales |$10,000 |$10,100 |$10,201 |

| |Sales on account |50,000 |50,500 |51,005 |

| |Total budgeted sales |$60,000 |$60,600 |$61,206 |

| | | | | |

| |Schedule of Cash Receipts | | | |

| | |Jan |Feb |Mar |

| |Current cash sales |$10,000 |10,100 |10,201 |

| |Plus: Collections from accts. rec. |48,000 |50,000 |50,500 |

| |Total budgeted collections |$58,000 |60,100 |60,701 |

| | | | | |

| | | | | |

| |Growth Rate of Sales | |0.02 | |

| |Sales Budget | | | |

| | |Jan |Feb |Mar |

| |Cash sales |$10,000 |$10,200 |$10,404 |

| |Sales on account |50,000 |51,000 |52,020 |

| |Total budgeted sales |$60,000 |$61,200 |$62,424 |

| | | | | |

| |Schedule of Cash Receipts | | | |

| | |Jan |Feb |Mar |

| |Current cash sales |$10,000 |$10,200 |$10,404 |

| |Plus: Collections from accts. rec. |48,000 |50,000 |51,000 |

| |Total budgeted collections |$58,000 |$60,200 |$61,404 |

| | | | | |

| |Growth Rate of Sales | |0.04 | |

| |Sales Budget | | | |

| | |Jan |Feb |Mar |

| |Cash sales |$10,000 |$10,400 |$10,816 |

| |Sales on account |50,000 |52,000 |54,080 |

| |Total budgeted sales |$60,000 |$62,400 |$64,896 |

| | | | | |

| | | | | |

| |Schedule of Cash Receipts | | | |

| | |Jan |Feb |Mar |

| |Current cash sales |$10,000 |$10,400 |$10,816 |

| |Plus: Collections from accts. rec. |48,000 |50,000 |52,000 |

| |Total budgeted collections |$58,000 |$60,400 |$62,816 |

| | | | | |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download