

|
|
|
Accounting 211 Tuesday, April 13th, 1999 Announcements: Exam #3 Results: Range = 13-100, Average = 67.4%, Average to date = 68.2% At this point, A = 88, B = 78, C = 68, D = 58 Lecture notes: Example:
Sales Price per Unit 800,000 / 50,000 = $16 VC per Unit 600,000 / 50,000 = $12 CM per Unit 200,000 / 50,000 = $4
100 x 4 = $400 Change in sales = 1,600
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Budgeted Inventory Levels |
||
|
12/1 |
12/31 |
|
|
Finished Goods |
3,000 units |
2,500 units |
|
Direct Materials |
5,000 lbs. |
6,000 lbs. |
What is the budgeted production for the month of December? 11,500 units
How many pounds of materials need to be purchased during December? 24,000 lbs.
Budgeted Production
|
Budgeted sales |
12,000 |
|
+ end inventory |
+ 2,500 |
|
# units needed |
14,500 |
|
- beginning inventory |
- 3,000 |
|
11,500 |
Budgeted Purchases
|
Units needed |
23,000 |
|
+ end inventory |
+ 6,000 |
|
# raw materials needed |
29,000 |
|
- beginning inventory |
- 5,000 |
|
24,000 |
|
Budgeted Unit Sales |
||
|
Dec 98 |
8,000 |
|
|
Jan 99 |
7,000 |
|
|
Feb 99 |
7,500 |
|
|
Mar 99 |
7,400 |
|
The company's policy is to maintain a finished goods inventory equal to 40% of the following month's sales.
How many units will be produced during Feb 99?
|
Unit sales, Feb |
7,500 |
|
+ end inventory, Feb |
2,960 |
|
# units needed |
10,460 |
|
- beginning inventory |
- 3,000 |
|
7,460 |
|
Budgeted Sales |
||
|
On Account |
Cash |
|
|
Dec 98 |
100,000 |
25,000 |
|
Jan 99 |
125,000 |
35,000 |
|
Feb 99 |
130,000 |
37,000 |
|
Mar 99 |
128,000 |
34,000 |
Sales on account are collected as follows: 40% during the month of sales, 60% following the month of sales
Budgeted Cash Collections from Sales:
|
January 99 |
|
|
Cash sales |
35,000 |
|
Collection on account, Jan sales |
50,000 |
|
Collection on account, Dec sales |
60,000 |
|
145,000 |
|
|
February 99 |
|
|
Cash sales |
37,000 |
|
Collection on account, Feb sales |
52,000 |
|
Collection on account, Jan sales |
75,000 |
|
164,000 |
|
Purchases Budget |
||
|
On Account |
Cash |
|
|
Dec 98 |
50,000 |
20,000 |
|
Jan 99 |
60,000 |
25,000 |
|
Feb 99 |
68,000 |
28,000 |
|
Mar 99 |
65,000 |
30,000 |
70% of the purchases on account are paid for in the month of purchase, and the remaining 30% are paid for in the month following the purchase
Budgeted Cash Payments for Purchases:
|
January 99 |
|
|
Cash purchases |
25,000 |
|
Cash payments on account, Jan |
42,000 |
|
Cash payments on account, Dec |
15,000 |
|
82,000 |
|
|
February 99 |
|
|
Cash purchases |
28,000 |
|
Cash payments on account, Feb |
47,600 |
|
Cash payments on account, Jan |
18,000 |
|
93,600 |