Budgeting, Production, Cash, and Master Budget: Discussion Questions
Budgeting, Production, Cash, and Master Budget: Discussion Questions
Budgeting, Production, Cash, and Master Budget: Discussion Questions
1. Budgets are the quantitative expressions of adjusted forecast then becomes the sales
plans. Budgets are used to translate the budget.
goals and strategies of an organization into
operational terms. 7. Yes. All budgets are founded on the sales
budget. Before a production budget can be
2. Control is the process of setting standards, created, it must have the planned sales. The
receiving feedback on actual performance, manufacturing budgets, in turn, depend on
and taking corrective action whenever actual the production budget. The same is true for
performance deviates materially from the financial budgets since sales are a
planned performance. Budgets are critical input for budgets in that category.
standards, and they are compared with
actual costs and revenues to provide 8. Goal congruence is important because it
feedback. means that the employees of an
organization are working toward the goals of
3. The planning and control functions of that organization.
budgeting can benefit all organizations,
regardless of size. All organizations need to 9. Frequent feedback is important so that
determine what their goals are and how best corrective action can be taken, increasing
to obtain those goals. This is the planning the likelihood of achieving budgetary goals.
function of budgeting. In addition,
10. Both monetary and nonmonetary incentives
organizations can compare what actually are used to encourage employees of an
happens with what was planned to see if the organization to achieve the organization’s
plans are unfolding as anticipated. This is
goals. Monetary incentives appeal to the
the control function of budgeting. economic needs of an individual, and
4. Budgeting forces managers to plan, nonmonetary incentives appeal to their
provides resource information for decision psychological needs. Since individuals are
making, sets benchmarks for control and motivated by both economic and
evaluation, and improves the functions of psychological factors, both types of
communication and coordination. incentives ought to be present in a good
budgetary system.
5. A master budget is the collection of all
individual area and activity budgets. 11. Participative budgeting is a system of
Operating budgeting that gives subordinate managers
budgets are concerned with the income- a say in how the budgets are established.
generating activities of a firm. Financial Participative budgeting fosters creativity and
budgets are concerned with the inflows and communicates a sense of responsibility to
outflows of cash and with planned capital subordinate managers. It also creates a
expenditures. higher likelihood of goal congruence since
managers have more of a tendency to make
6. The sales forecast is a critical input for the budget’s goals their own personal goals.
building the sales budget. However, it is not
necessarily equivalent to the sales budget. 12. Agree. Individuals who are not challenged
Upon receiving the sales forecast, tend to lose interest and maintain a lower
management may decide that the firm can level of performance. A challenging, but
do better than the forecast indicates. achievable, budget tends to extract a higher
Consequently, actions may be taken to level of performance.
increase the sales potential for the coming
year (e.g., increasing advertising). This 13. Top management should provide guidelines
and statistical input (e.g., industrial
Memorsave Inc.
Sales Budget
For the Coming Quarter
Quarter
July August September Total
Units 56,000 59,000 61,000 176,000
× Price × $52 × $52 × $52 × $52
Sales $2,912,000 $3,068,000 $3,172,000 $9,152,000
Memorsave Inc.
Production Budget
For the Coming Quarter
July August September Total
Sales in units 56,000 59,000 61,000 176,000
Desired ending inventory 17,700 18,300 16,500* 16,500
Total needs 73,700 77,300 77,500 192,500
Less: Beginning inventory 7,400 17,700 18,300 7,400
Units to be produced 66,300 59,600 59,200 185,100
*October sales of 55,000 × 0.30 = 16,500
November:
Sales 1,060 868
Desired ending inventory 459 312
Total needs 1,519 1,180
Less: beginning inventory 265 217
Merchandise to be ordered 1,254 963
Cost per unit $ 320 $ 130
December:
Sales 1,835 1,246
Desired ending inventory 54 25
Total needs 1,889 1,271
Less: beginning inventory 459 312
Merchandise to be ordered 1,430 959
Cost per unit $ 320 $ 130
Okeke Company
Cost of Goods Sold Budget
For the Coming Year
Direct materials ($14 × 20,000) ....................................................... $280,000
Direct labour (1.9 × $16 × 20,000) ................................................... 608,000
Variable overhead (1.9 × $1.20 × 20,000) ....................................... 45,600
Fixed overhead (1.9 × $1.60 × 20,000)............................................ 60,800
Total manufacturing cost ............................................................... 994,400
Less: Ending inventory ($49.72* × 675) ......................................... 33,561
Cost of goods sold .......................................................................... $960,839
Fael Company
Selling and Administrative Expenses Budget
For the Coming Year
Variable selling expenses (0.03 × $19,730,000) ....... $ 591,900
Fixed expenses:
Salaries .................................................................. $ 960,000
Utilities ................................................................... 365,000
Office space .......................................................... 230,000
Advertising ............................................................ 1,200,000
Total fixed expenses............................................. 2,755,000
Total selling and administrative expenses .............. $3,346,900
Azizi Company
Budgeted Income Statement
For the Coming Year
Sales ($10.80 × 160,000) ................................................................. $1,728,000
Cost of goods sold ($6.30 × 160,000) ............................................ 1,008,000
Gross margin ................................................................................... 720,000
Less: Variable selling and administrative
expenses ($1.10 × 160,000) ....................................................... 176,000
Fixed selling and administrative expenses ................................... 423,000
Operating income ............................................................................ 121,000
Less: Income taxes (0.35 × $135,000) ............................................ 42,350
Net income ....................................................................................... $ 78,650
2.
Royal Company
Production Budget
For the Quarter Ending June 30
3.
Royal Company
Direct Materials Purchases Budget
For the Quarter Ending June 30
5.
Royal Company
Overhead Budget
For the Quarter Ending June 30
6.
Royal Company
Ending Finished Goods Inventory Budget
For the Quarter Ending June 30
8.
Royal Company
Selling and Administrative Expense Budget
For the Quarter Ending June 30
9.
Royal Company
Budgeted Income Statement
For the Quarter Ending June 30
Quarter
Sales $ 682,500
Less: cost of goods sold 299,165
Gross margin 383,335
Less: selling and admin 242,500
Operating income 140,835
Less: interest expense 374
Net income $ 140,461
11.
Royal Company
Schedule of Expected Cash Disbursements
For the Quarter Ending June 30
Less disbursements:
Direct materials (14,213) (9,252) (12,654) (36,119)
Direct labour (11,400) (35,100) (28,560) (75,060)
Overhead (36,900) (60,600) (54,060) (151,560)
Selling and admin (65,000) (75,000) (72,500) (212,500)
Equipment (43,700) (12,250) (55,950)
Dividend (15,000) (15,000)
Total disbursements (127,513) (223,652) (195,024) (546,189)
Financing
Borrowings 14,013 14,013
Repayments (14,013) (14,013)
Interest (374)* (374)
Total Financing 14,013 (14,387) (374)
Interest payment is 2/12 x 0.16 x $14,013 since borrowing occurs at the beginning
of the month and payment is at the end of the following month.
Current assets:
Cash $127,187
Accounts receivable 78,750
Raw materials inventory 1,708*
Finished goods inventory 11,730
Total current assets 219,375
Current liabilities:
Accounts payable $ 5,614
Shareholders’ equity:
Common shares 200,000
Retained earnings 234,711**
Total liabilities and shareholders’ equity $440,325
* rounded
** Opening retained earnings + net income – dividends ($109,250 + $140,461 –
$15,000)
Exercise 9–15
a. 10
b. 8
c. 9
d. 2
e. 5
f. 3, 6, 7
g. 4
h. 1, 3
i. 1
Exercise 9–16
1. Imperial Doors
Sales Budget
For the Year 2017
1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Total
Frosted23:
Units 950 1,800 2,400 3,100 8,250
× Price × $250 × $250 × $250 × $250 × $250
Sales $237,500 $ 450,000 $600,000 $775,000 $ 2,062,500
,
Frosted26:
Units 1,200 2,300 3,250 3,500 10,250
× Price × $375 × $375 × $375 × $375 × $375
Sales $450,000 $ 862,500 $1,218,750 $ 1,312,500 $ 3,843,750
Total sales $687,500 $1,312,500 $1,818,750 $2,087,500 $5,906,250
2. Imperial Doors will use the sales budget in planning as the basis for the
production budget and the succeeding budgets of the master budget. During
the year, the company can compare actual sales against the budget to see if
expectations are being achieved.
Imperial Doors
Production Budget for Frosted23
For the Year 2017
1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Total
Sales in units 950 1,800 2,400 3,100 8,250
Desired ending inventory 360 480 620 202 202
Total needs 1,310 2,280 3,020 3,302 8,452
Less: Beginning inventory 220 360 480 620 220
Units produced 1,090 1,920 2,540 2,682 8,232
Imperial Doors
Production Budget for Frosted26
For the Year 2017
1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Total
Sales in units 1,200 2,300 3,250 3,500 10,250
Desired ending inventory 230 325 350 148 148
Total needs 1,430 2,625 3,600 3,648 10,398
Less: Beginning inventory 170 230 325 350 170
Units produced 1,260 2,395 3,275 3,298 10,228
2. Peanut-Fresh Inc.
Direct Materials Purchases Budget
For January and February
Jars:
January February Total
Production 42,700 47,800 90,500
× 1 jar × 1 × 1 × 1
Jars for production 42,700 47,800 90,500
Desired ending inventory 4,780 5,560 5,560
Total needs 47,480 53,360 96,060
Less: Beginning inventory 4,270 4,780 4,270
Jars purchased 43,210 48,580 91,790
Peanuts:
January February Total
Production 42,700 47,800 90,500
× 340 grams × 340 × 340 × 340
Grams for production 14,518,000 16,252,000 30,770,000
Desired ending inventory 1,625,200 1,890,400 1,890,400
Total needs 16,143,200 18,142,400 32,660,400
Less: Beginning inventory 1,451,800 1,625,200 1,451,800
Grams purchased 14,691,400 16,517,200 31,208,600
De Silva Inc.
Production Budget
For the First Quarter of the Year
January February March Total
Sales in units 180,000 220,000 200,000 600,000
Desired ending inventory 55,000 50,000 60,000 60,000
Total needs 235,000 270,000 260,000 660,000
Less: Beginning inventory 21,000 55,000 50,000 21,000
Units to be produced 214,000 215,000 210,000 639,000
Exercise 9–20
Tsiklauri Company
Direct Materials Purchases Budget
For March, April, and May
March April May Total
Units to be produced 3,500 4,400 4,900 12,800
Direct materials per unit
(grams) × 425 × 425 × 425 × 425
Production needs 1,487,500 1,870,000 2,082,500 5,440,000
Desired ending inventory
(grams) 374,000 416,500 535,500 535,500
Total needs 1,861,500 2,286,500 2,618,000 5,975,500
Less: Beginning inventory 297,500 374,000 416,500 297,500
Direct materials to be
purchased (grams) 1,564,000 1,912,500 2,201,500 5,678,000
Bundles of 10 grams 156,400 191,250 220,150 567,800
Cost per 10 grams × $0.34 × $0.34 × $0.34 × $0.34
Total purchase cost $ 53,176 $65,025 $74,851 $ 193,052
Typefast Inc.
Direct Labour Budget
For October, November and, December
October November December Total
Units to be produced 35,000 42,000 51,000 128,000
Direct labour time per
bundle (hours) × 0.30 × 0.30 × 0.30 × 0.30
Total hours needed 10,500 12,600 15,300 38,400
Cost per hour × $18 × $18 × $18 × $18
Total direct labour cost $189,000 $226,800 $275,400 $691,200
Exercise 9–22
Abbasov Inc.
Sales Budget
For the Coming Year
Model Units Price Total Sales
LB-1 36,750 $32.00 $1,176,000
LB-2 18,900 20.00 378,000
WE-6 25,200 10.50 264,600
WE-7 17,010 10.00 170,100
WE-8* 13,800 18.00 248,400
WE-9* 8,000 22.00 176,000
Total $2,413,100
*Recall that WE-8 and WE-9 sales from last year were only from the last two
quarters. Current year sales are estimated to be two times those amounts.
3. December includes the Christmas holiday season and is a time when many
gifts are given. Raylene has factored this into her budgeting. January, on the
other hand, is a month with fewer holidays or gift-giving occasions. As a
result, Raylene has forecast fewer gift baskets.
2. Janzen Inc.
Schedule of Cash Receipts
For August
Payments on account:
From June credit sales:
(0.23 × $260,000) .............................................................. $ 59,800
From July credit sales:
(0.55 × $240,000) .............................................................. 132,000
From August credit sales:
(0.20 × $300,000) .............................................................. 60,000
Less: August cash discount (0.02 × $60,000) .................... (1,200)
Cash receipts ........................................................................ $250,600
Exercise 9–26
Fein Company
Schedule of Cash Payments
For August
Payments on accounts payable:
From July purchases (0.80 × $77,000) ........................................... $ 61,600
From August purchases (0.20 × $73,000) ...................................... 14,600
Direct labour payments:
From July (0.10 × $32,300) ........................................................ 3,230
From August (0.90 × $35,400) ................................................... 31,860
Overhead ($71,200 – $6,350) .......................................................... 64,850
Loan repayment [$15,000 + ($15,000 × 0.09 × 4/12)] ..................... 15,450
Cash payments .......................................................................... $191,590
1. Cash Budget
For June
Beginning cash balance ....................................... $ 736
Collections:
Cash sales ........................................................ 18,600
Credit sales:
Current month ($54,000 × 40%) ................. 21,600
May credit sales ($35,000 × 30%) .............. 10,500
April credit sales* ....................................... 5,896
Total cash available .............................................. $57,332
Less disbursements:
Inventory purchases:
Current month ($72,600 × 64% × 20%)...... 9,293
Prior month ($53,000 × 64% × 80%) .......... 27,136
Salaries and wages ......................................... 11,750
Rent .................................................................. 4,100
Taxes ................................................................ 6,780
Total cash needs ........................................ 59,059
Excess of cash available over needs .................. $ (1,727)
*$28,900 × 20% = $5,780
$5,780 × 0.02 = $116
$5,780 + $116 = $5,896
2. Yes, the business does show a negative cash balance for the month of June. A
negative budgeted cash balance is unacceptable. The easiest way to deal with
it would be for the owner to consider taking less cash salary.
Problem 9–28
Problem 9–29
1. Hopewell Manufacturing
For the Quarter Ended March 31
a. Schedule 1: Sales Budget
January February March Total
Units 80,000 90,000 95,000 265,000
Selling price × $298 × $298 × $298 × $298
Sales $23,840,000 $26,820,000 $28,310,000 $78,970,000
9-26
c. Schedule 3: Direct Materials Purchases Budget
2.
Victor Company
Budgeted Income Statement
For the Month Ended December 31
Sales (Schedule 1) $2,880,000
Cost of goods sold 1,920,000*
Gross margin 960,000
Selling and administrative expenses 225,000
Miscellaneous expenses 61,500
Net income $ 673,500
*240,000 x $8 = $1,920,000
4. The sales budget is the basis for all of the other operating budgets and most
of the financial budgets; therefore it is very important the sales budget be as
accurate as possible. If the sales forecast is estimated too low, that is, if the
estimate is below demand, the company may not purchase enough inventory.
This can lead to lost sales and additional expenditures as the company pays
suppliers a premium for rush delivery.
On the other hand, if the sales forecast is estimated too high, the company
may purchase too much inventory in which case they have to pay to store the
inventory until it is sold. Additionally, the cash used to purchase the inventory
is then not available to be used for other, more profitable, investments and the
company faces risks such as inventory damage or obsolescence.
Given accounts payable, the total liabilities plus shareholders’ equity must
equal $562,750 ($84,000 + $210,000 + $268,750). Cash is the difference between
total assets and all other assets except cash ($562,750 – $425,000 – $36,000 –
$88,200). This difference is $13,550.
Assets L & SE
Cash ....................................................................... $ 13,550
Accounts receivable ............................................. 88,200
Inventory ................................................................ 36,000
Plant and equipment............................................. 425,000
Accounts payable ................................................. $ 84,000
Common shares .................................................... 210,000
Retained earnings ................................................. 268,750
Total .................................................................. $562,750 $562,750
2. Attar Retailers
Cash Budget
For the Quarter Ending September 30, 2017
July August September Total
Beginning cash balance $ 13,550 $ 10,450 $ 10,405 $ 13,550
Cash collections* 102,600 100,700 113,300 316,600
Total cash available 116,150 111,150 123,705 330,150
Cash disbursements:
Purchases** 84,000 76,000 94,000 254,000
Salaries and wages 10,000 10,000 10,000 30,000
Utilities 1,000 1,000 1,000 3,000
Other 1,700 1,700 1,700 5,100
Property taxes 15,000 15,000
Advertising fees 6,000 6,000
Lease 5,000 5,000
Total disbursements 111,700 94,700 111,700 318,100
Minimum cash balance 10,000 10,000 10,000 10,000
Total cash needs 121,700 104,700 121,700 328,100
Excess (deficiency) (5,550) 6,450 2,005 2,050
Financing:
Borrowings 6,000 6,000
Repayments (6,000) (6,000)
Interest*** (45) (45)
Total financing 6,000 (6,045) (45)
Ending cash balance $ 10,450 $ 10,405 $ 12,005 $ 12,005
*Cash collections:
Cash sales $ 27,000 $ 30,000 $ 40,500 $ 97,500
Credit sales:
Current month 12,600 14,000 18,900 45,500
Prior month 42,000 31,500 35,000 108,500
From two months ago 21,000 25,200 18,900 65,100
Total collections $102,600 $100,700 $113,300 $316,600
**Taken from the purchase schedule developed in Requirement 1
***$6,000 × 0.09/12
Note: Depreciation is not a cash expense and so does not appear in the budget.
3. Attar Retailers
Pro Forma Balance Sheet
September 30, 2017
Assets L & SE
Cash ....................................................................... $ 12,005
Accounts receivablea ............................................ 96,600
Inventoryb .............................................................. 44,000
Plant and equipmentc ........................................... 413,000
Accounts payableb ................................................ $ 98,000
Common shares .................................................... 210,000
Retained earningsd ............................................... 257,605
Total .................................................................. $565,605 $565,605
a
(0.7 × $135,000 × 0.8) + (0.7 × $100,000 × 0.3)
b
From purchases schedule prepared in Requirement 1
c
[$425,000 – 3($4,000)]
d
If total assets equal $565,605, then liabilities plus shareholders’ equity must
also equal that amount. Subtracting accounts payable and common shares from
total liabilities and shareholders’ equity gives retained earnings of $257,605.
Munishi Company
Cash Budget
For the Month of October
Beginning cash balance ................................................................. $ 35,000
Collections:
Cash sales (0.45 × $990,000) ..................................................... 445,500
Credit sales:
October:
Before discounta.............................................................. 190,575
Less: discountb ............................................................... (953)
Septemberc............................................................................ 180,400
Augustd .................................................................................. 72,738
Sale of old equipment ..................................................................... 12,500
Total cash available ................................................................... 935,760
Less disbursements:
Raw materials:
Octobere ................................................................................ 204,480
Septemberf ............................................................................ 158,400
Direct labour ............................................................................... 110,000
Operating expenses................................................................... 328,000
Dividends .................................................................................... 115,000
Equipment .................................................................................. 124,000
Total disbursements ............................................................ 1,039,880
Minimum cash balance ................................................................... 10,000
Total cash needs ........................................................................ 1,049,880
Excess of cash required (borrowed) ............................................. (114,120)
1. Chistosa Company
Direct Materials Purchases Budget for Fabric
For the Fourth Quarter
October November December Total
Units to be produced .................... 20,000 40,000 25,000 85,000
DM per unit (m).............................. × 0.20 × 0.20 × 0.20 × 0.20
Production needs .................... 4,000 8,000 5,000 17,000
Desired ending inventory (m) ...... 1,200 750 900 900
Total needs............................... 5,200 8,750 5,900 17,900
Less: Beg. inventory..................... 600 1,200 750 600
DM to be purchased (m) .......... 4,600 7,550 5,150 17,300
Cost per metre............................... × $3.50 × $3.50 × $3.50 × $3.50
Total purchase cost ................. $16,100 $26,425 $18,025 $60,550
2. Chistosa Company
Direct Materials Purchases Budget for Polyfiberfill
For the Fourth Quarter
October November December Total
Units to be produced ................. 20,000 40,000 25,000 85,000
DM per unit (g)............................ × 6 × 6 × 6 × 6
Production needs ................. 120,000 240,000 150,000 510,000
Desired ending inventory (g) .... 72,000 45,000 54,000 54,000
Total needs............................ 192,000 285,000 204,000 564,000
Less: Beg. inventory.................. 36,000 72,000 45,000 36,000
DM to be purchased (g) ........ 156,000 213,000 159,000 528,000
Cost per gram............................. × $0.05 × $0.05 × $0.05 × $0.05
Total purchase cost .............. $ 7,800 $ 10,650 $ 7,950 $26,400
3. Chistosa Company
Direct Labour Budget
For the Fourth Quarter
October November December Total
Units to be produced .............. 20,000 40,000 25,000 85,000
Direct labour time per
unit (hours)......................... × 0.10 × 0.10 × 0.10 × 0.10
Total hours needed ................. 2,000 4,000 2,500 8,500
Wages per hour ....................... × $15.50 × $15.50 × $15.50 × $15.50
Total direct labour cost ..... $ 31,000 $62,000 $38,750 $131,750
a. August
Cash sales ($75,000 × 1.20 x 0.05) ............ $ 4,500
Credit card sales ($75,000 x 1.20 x 0.95)… 85,500
Revised total sales for August ....................... $90,000
September
Cash sales ($80,000 × 1.20 x 0.05) ............ $ 4,800
Credit card sales ($80,000 x 1.20 x 0.95)… 91,200
Revised total sales for September ................. $96,000
Less:
Gateway and statement fee -19 -19
Transaction fees:
1,710 x $0.25 -428
1,824 x $0.25 -456
Q1 Q2 Q3 Q4 Year
Sales in units 1,320 1,760 880 440 4,400
Desired ending inventory 528 264 132 436 436
Total needs 1,848 2,024 1,012 876 4,836
Less: Beginning
inventory 375 528 264 132 375
Units to be produced 1,473 1,496 748 744 4,461
Note: Quarter 1, 2019 units to be produced: 1,452 + (1,760 * 1.1 *.30) - 436 = 1,597
units
* (1,597 x 0.25)
Fittings
Q1 Q2 Q3 Q4 Year
Units to be produced 1,473 1,496 748 744 4,461
Direct materials per unit x1 x1 x1 x1 x1
Production needs 1,473 1,496 748 744 4,461
Desired ending inventory 374 187 176 399 399
Total needs 1,847 1,683 924 1,143 4,860
Less: Beginning inventory 325 374 187 176 325
Direct materials to be
purchased 1,522 1,309 737 967 4,535
Cost per unit $50 $50 $50 $50 $50
Total purchase cost—
fittings $76,100 $65,450 $36,850 $48,350 $226,750
Q1 Q2 Q3 Q4 Year
Units to be produced 1,473.00 1,496.00 748.00 744.00 4,461.00
Direct labour time per
unit in hours 0.50 0.50 0.50 0.50 0.50
Total hours needed
736.50 748 374 352 2,210.50
Average wage per hour $36 $36 $36 $36 $36
Total direct labour cost $26,514 $26,928 $13,464 $12,672 $79,578
Overhead Budget
Q1 Q2 Q3 Q4 Year
Budgeted direct labour
hours 736.50 748 374 352 2,210.50
Variable overhead rate
per labour hour $20 $20 $20 $20 $20
Budgeted variable
overhead $14,730 $14,960 $7,480 $7,040 $44,210
Fixed overhead rate
per labour hour $30 $30 $30 $30 $30
Fixed overhead $22,095 $22,440 $11,220 $10,560 $66,315
Total overhead $36,825 $37,400 $18,700 $17,600 $110,525
Beginning Ending
Snowboards 375 436
Unit cost $235 $235
Total ending inventory $88,125 $102,460
Q1 Q2 Q3 Q4 Year
Planned sales in units 1,320 1,760 880 440 4,400
Variable selling and
administrative
commissions @ 5% of
sales $33,000 $44,000 $22,000 $11,000 $110,000
Bad debt expense @
2% of credit sales 11,880 15,840 7,920 3,960 39,600
Total variable expenses 44,880 59,840 29,920 14,960 149,600
Fixed selling and
administrative
expenses:
Salaries 46,375 46,375 46,375 46,375 185,500
Facilities rental 7,500 7,500 7,500 7,500 30,000
Advertising and
promotion 6,250 6,250 6,250 6,250 25,000
Depreciation 4,500 4,500 4,500 4,500 18,000
Professional fees 3,750 3,750 3,750 3,750 15,000
Office expenses 3,750 3,750 3,750 3,750 15,000
Total fixed expenses 72,125 72,125 72,125 72,125 288,500
Total selling and
administrative
expenses $117,005 $131,965 $102,045 $87,085 $438,100
Year
Sales $ 2,200,000
Less: Cost of goods sold 1,032,280
Gross margin 1,167,720
Less: Selling & admin.
expenses 438,100
Operating income 729,620
Less: Interest expense 18,000
Net Income before taxes 711,620
Less: Income taxes 284,648
Net Income $ 426,972
Q1 Q2 Q3 Q4 Year
Cash Sales $ 66,000 $ 88,000 $ 44,000 $ 22,000 $ 220,000
Received on account from:
Quarter 3, 2014 28,800 28,800
Quarter 4, 2014 108,000 14,400 122,400
Quarter 1, 2015 178,200 356,400 47,520 582,120
Quarter 2, 2015 237,600 475,200 63,360 776,160
Quarter 3, 2015 118,800 237,600 356,400
Quarter 4, 2015 59,400 59,400
Total Cash Collections $381,000 $696,400 $685,520 $382,360 $2,145,280
Q1 Q2 Q3 Q4 Year
Boards $216,124 $185,878 $104,654 $137,314 $643,970
Fittings 76,100 65,450 36,850 48,350 226,750
Total $292,224 $251,328 $141,504 $185,664 $870,720
Timing Q1 Q2 Q3 Q4 Year
Quarter
4, 2014 $85,000 $85,000
Quarter
1, 2015* 233,779 $58,445 292,224
Quarter
2, 2015* 201,062 $50,266 251,328
Quarter
3, 2015* 113,203 $28,301 141,504
Quarter
4, 2015* 148,531 148,531
$318,779 $259,507 $163,469 $176,832 $918,587
* rounded
Cash Budget
Q1 Q2 Q3 Q4 Year
Beginning cash balance 48,000 151,757 184,197 380,959 48,000
Cash sales and
collections on account 381,000 696,400 685,520 382,360 2,145,280
Total cash available 429,000 848,157 869,717 763,319 2,193,280
Less Disbursements:
Direct materials 318,779 259,507 163,469 176,832 918,587
Direct labour 26,514 26,928 13,464 12,672 79,578
Overhead 36,825 37,400 18,700 17,600 110,525
Selling & admin. 117,005 131,965 102,045 87,085 438,100
Equipment 100,000 125,000 225,000
Income taxes 284,648 284,648
Less: Bad debt
expense (11,880) (15,840) (7,920) (3,960) (39,600)
Less: Depreciation (10,000) (10,000) (10,000) (10,000) (40,000)
Total Disbursements 577,243 554,960 279,758 564,877 1,976,838
Excess (Deficiency) of
Cash (148,243) 293,197 589,959 198,442 216,442
Financing:
Borrowings 300,000 300,000
Repayments (100,000) (200,000) (300,000)
Interest (9,000) (9,000) (18,000)
Total Financing 300,000 (109,000) (209,000) (18,000)
Ending cash balance 151,757 184,197 380,959 198,442 198,442
In Quarter 2, the interest payment is 6/12 x 0.06 x $300,000 since borrowing occurs
at the beginning of the quarter and payment is at the end of the following quarter.
In Quarter 3, the interest payment is 9/12 x 0.06 x $200,000 since borrowing occurs
at the beginning of the quarter and payment is at the end of the following quarter.
Current assets:
Cash $ 198,442
Accounts receivable, net 166,320
Raw materials inventory 76,608
Finished goods inventory 102,460
Total current assets 543,830
Property, plant, and equipment:
Land 66,075
Building and equipment 373,000
Accumulated depreciation (108,700)
Total PP&E 330,375
Total assets $ 874,205
Current liabilities:
Accounts payable 37,133
Owner's equity:
Retained earnings* 837,072
Total liability & owner's equity $ 874,205
Problem 9–38
Answers will vary.
a. Cee Dee
Needs: Sales in units 12,000 9,000
Ending inventory 300 200
Less beginning inventory (400) (150)
Production budget 11,900 9,050
c. Cee Dee
Hours: 11,900 × 5 | 9,050 × 8 59,500 72,400
Hourly rate $14 $14
Direct labour budget $833,000 $1,013,600
d. Cee Dee
Manufacturing cost per unit
RM1: 10 × $2 | 8 × $2 $20.00 $16.00
RM2: 4 × $2.50 10.00
RM3: 2 × $0.50 | 1 × $0.50 1.00 0.50
Direct labour: 5 hrs × $14 | 8 hrs × $14 70.00 112.00
Manufacturing overhead
Rate: $263,800 / (59,500 + 72,400)
= $263,800 / 131,900 hours
= $2 per DLH
5 hrs × $2 | 8 hrs × $2 10.00 16.00
$101.00 $154.50
*
© CPA Ontario.
Cash collections:
Oct. sales: 70,000 × $5 × 10% $ 35,000
Nov. sales: 50,000 × $5 × 40% 100,000
Dec. sales: 50,000 × $5 × 50% × 0.98 122,500 257,500
Cash disbursements:
Direct materials 60,000
Direct labour
Regular time: 75,000 bats / 7.5 × $15 150,000
Overtime: 15,000 bats / 7.5 × $15 × 1.5 45,000
Overhead:
Variable: 90,000 bats × $0.30 27,000
Fixed: ($280,000 – $40,000) / 12 20,000
Selling:
Variable: 50,000 × $0.20 10,000
Fixed: $60,000 / 12 5,000
Fixed administrative: $120,000 / 12 10,000
Prepaid expenses: $4,200 ending balance
– ($4,800 opening balance – 3,600 expired in 3,000
December)
Income taxes 50,000
Note payment: $144,000 / 24 6,000
Interest on note payable:
[$144,000 - (6,000 × 7)] × 1% 1,020
Dividend payment: 7,000 shares × $0.20 1,400 (388,420)
Cash balance before financing (110,920)
Liquidation of temporary investments 40,000
Borrowing 80,920
Cash balance, end $10,000
Case 9–41
1. Budgets help business owners and managers to plan ahead, and later,
exercise control by comparing what actually happened to what was expected
in the budget. Budgets formalize managers’ expectations regarding sales,
prices, and costs. Even small businesses and non-profit entities can benefit
from the planning and control provided by budgets. Budgets are aids in
planning, communicating, setting standards of performance, motivating
personnel toward goals, measuring results, and directing attention to problem
areas that need investigation. Rajvir should use the budget as explained
above.
2. Merits include:
a. Forces managers to think about and plan (defines goals and objectives)
b. Provides information that can be used to improve decision making (e.g.,
can help efficiently allocate resources)
c. Provides a standard for performance evaluation
d. Improves communication and coordination (uncovers potential
bottlenecks)
3. We can improve the process by recognizing the nature of the volatile industry
in the budget (e.g., better calibrate the budget for the seasonality of demand
with each passing year) and by providing a rolling budget such that 12
months of forecasts are always available. This is a new company, and the
more data available to identify trends and opportunities, the better.
2. Dr. Jones must either increase revenues to make up the deficiency or cut
costs or a combination of the two. Three possible approaches are outlined as
follows:
a. Extend office hours so that a total of 40 hours are worked each week. This
could increase revenues by as much as $5,340. Based on a four-week
month, the current revenue earned per hour is $166.88 ($21,360/128). Thus,
the total revenue increase possible is $166.88 × 32 hours = $5,340. Dr.
Jones would need to inform his assistants and receptionist of the
increased time and indicate that each will receive approximately a 25
percent increase in salary for the additional time. (The office is currently
open 32 hours per week, so the hours are increasing by 25%.) The
hygienist is fully utilized, so we assume no increased hours or wages for
the hygienist. Benefits (primarily CPP and employment insurance benefits)
would also increase. Other expenses that will likely increase with an
increase in sales are dental supplies, utilities, and lab fees (representing
about 31 percent of sales). The remaining expenses appear to be fixed.
Thus, the increase in cash flow is computed as follows:
Incremental revenues $ 5,340
Salary increases (0.25 × $3,400) (850)
Benefits ( $12,700
$1,344
)($850) (90)
* Dental supplies, utilities, and lab fees are variable expenses. The
proportion of total variable expenses of each is:
b. Cut one dental assistant, eliminate the salary to Mrs. Jones and the
activities she does, and cut Dr. Jones’s salary back by $1,000 per month.
The savings are as follows:
Assistant (salary and benefits) $1,051*
Salaries 2,000
Total $3,051
*($1,900/2) + [($950/$12,700) × $1,344] = $1,051 (rounded). (This provides a
reasonable approximation of the benefits assigned to an assistant.)
Although this achieves the savings, the solution may not be feasible. The
solution depends to a large extent on how well the Jones family can do
with a $2,000 per month cut in their income. In all likelihood, this would be
unacceptable to the Jones family. Also, cutting an assistant would require
the receptionist to become involved in assisting. This may not be possible
without laying off the receptionist and hiring a person that has both sets of
skills. Additionally, using the receptionist as an assistant would result in
phone calls going unanswered and/or incoming patients being ignored.
c. Increase the fees charged for the various dental services. Assuming a
variable cost ratio of 31 percent (from the first approach), the increase in
revenues needed to cover the $2,900 deficiency can be computed as
follows:
0.69R = $2,900
R = $2,900/0.69
R = $4,203
This increase would call for fees to increase an average of 19.7 percent.
Whether this increase is possible or not depends to some extent on how
Dr. Jones’s charges compare with other dentists in the area. If some
increase is possible, then the increase could be combined with elements of
the other two approaches, (e.g., a 10 percent increase in fees and working
an extra four hours per week, say, on Wednesday evening). Dr. Jones
would be more likely to accept such a combination rather than accepting
either of the other approaches in their pure form.
The behavioural principles discussed in the chapter do have a role in this
type of setting. Dr. Jones’s personal goals must be in line with the goals of
his professional organization, and he must have the motivation to achieve
those goals. There is, however, a significant difference. Dr. Jones owns
and manages the organization. To a large extent, his goals are the goals of
the organization.
Case 9–43