ACG 2071 Lecture Notes - Lecture 16: Budget, Cash Flow, Income Statement

49 views3 pages

chocolateleopard236

4 Nov 2018

School

University of Florida

Department

Accounting

Course

ACG 2071

Professor

Schadewald

For unlimited access to Class Notes, a Class+ subscription is required.

Document Summary

Sales budget is the basis of every other budget: starting place for budgeting, anticipated sales revenue. = total sales revenue: key estimates, unit sales, selling price per unit, credit sales versus cash sales? (impacts cash flow) Forecasting sales: accurate sales forecast is critical, factors to consider, general economic conditions, industry trends, company-specific analysis, market research studies, estimates made by sales force. Importance of sales budget: provides estimates of, number of units that must produce or purchase to meet budgeting sales, cash collections related to sales, timing of cash collections. Production budget: number of units that company must produce to, meet budgeted sales, and, provide desired ending finished goods inventory (safety stock, planned production. Importance of production budget: provides estimate of number of units to produce, provides basis for budgeting manufacturing costs, direct materials, direct labor, manufacturing overhead. Master budget for merchandising company: operating budgets (4, sales, merchandise purchases, sg&a expenses, income statement, financial budgets (3, same as manufacturer.

Related Questions

Comprehensive budgeting problem; activity-based costing,operating and financial budgets. Tyva makes a very popular undyedcloth sandal in one style, but in Regular and Deluxe. The Regularsandals have cloth soles and the Deluxe sandals have cloth-coveredwooden soles. Tyva is preparing its budget for June 2015 and hasestimated sales based on past experience.

Other information for the month of June follows:

Input Prices

Direct materials

Cloth $5.25 per yard

Wood $7.50 per board foot

Direct manufacturing labor $15 per direct manufacturinglabor-hour

Input Quantities per Unit of Output (per pair ofsandals)

	Regular	Deluxe
Direct materials
Cloth	1.3 yards	1.5 yards
Wood	0	2 b.f.
Direct manufacturing labor-hours	5 hours	7 hours
Setup hours per batch	2 hours	3 hours

Inventory Information, Direct Materials

	Cloth	Wood
Beginning inventory	610 yards	800 b.f.
Target ending inventory	386 yards	295 b.f.
Cost of beginning inventory	$3,219	$6,060

Tyva accounts for direct materials using a FIFO cost flowassumption.

Sales and Inventory Information, FinishedGoods

	Regular	Deluxe
Expected sales in units (pairs of sandals)	2,000	3.000
Selling price	$120	$195
Target ending inventory in units	400	600
Beginning inventory in units	250	650
Beginning inventory in dollars	$23,250	$92,625

Tyva uses a FIFO cost flow assumption for finished goodsinventory.

All the sandals are made in batches of 50 pairs of sandals. Tyvaincurs manufacturing overhead costs, marketing and generaladministration, and shipping costs. Besides materials and labor,manufacturing costs include setup, processing, and inspectioncosts. Tyva ships 40 pairs of sandals per shipment. Tyva usesactivity-based costing and has classified all overhead costs forthe month of June as shown in the following chart:

Cost Type	Denominator Activity	Rate
Manufacturing
Setup	Setup hours	$18 per setup hour
Processing	Direct man. Labor-hours	$1.80 per DMLH
Inspection	Number of pairs of sandals	$1.35 per pair
Nonmanufacturing
Marketing & general admin	Sales revenue	8%
Shipping	Number of shipments	$15 per shipment

Questions

1.Prepareeach of the following for June:

a.Revenuesbudget

b.Productionbudget in units

c.Directmaterial usage budget and direct material purchases budget in bothunits and dollars, round to dollars

d.Directmanufacturing labor cost budget

e.Manufacturing overhead cost budgets forsetup, processing, and inspection activities

f.Budgetedunit cost of ending finished goods inventory and ending inventoriesbudget

g.Cost ofgoods sold budget

h.Marketingand general administration and shipping costs budget

Tyvaâs balance sheet for May 31 follows.

TYVA BALANCE SHEET AS OF MAY 31

Assets
Cash		9,435
Accounts Receivable	324,000
Less: allowance for bad debts	16,200	307,800
Inventories
Direct materials		9,279
Finished goods		115,875
Fixed assets	870,000
Less: accumulated depreciation	136,335	733,665
Total assets		1,176,054

Liabilities and Equity

Liabilities and Equity
Accounts payable	15,600
Taxes payable	10,800
Interest payable	750
Long-term debt	150,000
Common stock	300,000
Retained earnings	698,904
Total liabilities & equity	1,176,054

Use the balance sheet and the following information to prepare acash budget for Tyva for June. Round to dollars.

All sales are on account; 60% are collected in the month of thesale, 38% are collected the following month, and 2% are nevercollected and written off as bad debts.

All purchases of materials are on account. Tyva pays for 80% ofpurchases in the month of purchase and 20% in the followingmonth.

All other costs are paid in the month incurred, including thedeclaration and payment of a $15,000 cash dividend in June.

Tyva is making monthly interest payments of 0.5% (6%per year) ona $150,000 long-term loan.

Tyva plans to pay the $10,800 of taxes owed as of May 31 in themonth of June. Income tax expense for June is zero.

30% of processing, setup, and inspection costs and 10% ofmarketing and general administration and shipping costs aredepreciation.

Prepare a budgeted income statement for June and a budgetedbalance sheet for Tyva as of June 30, 2015.

Listed below are the answers to the first question. Ijust need help with preparing a cash budget for June, and abudgeted income statement and budgeted balance sheet as of June30.

1
a.	Revenue Budget
	For the Month of June 2015
				Regular	Deluxe
	Expected sales in units			2,000	3,000
	Selling price			120	195
	Total sales			$240,000	$585,000

b.	Production Budget in Units
	For the Month of June 2015
						Regular	Deluxe
	Budgeted unit sales					2,000	3,000
	Add: target ending finished goods inventory					400	600
	Total required units					2,400	3,600
	Deduct: beginning finished goods inventory					250	650
	Units of finished goods to be produced					2,150	2,950

c.	Direct Material Usage Budget in Units andDollars
	For the Month of June 2015
	Direct materials required for
			Cloth	Wood	Cloth	Wood
		Units	Yards	B.F.	Total	Total
	Regular	2,150	1.3	0	2,795	0
	Deluxe	2,950	1.5	2	4,425	5,900
					7,220	5,900
	Cost Budget - to be purchased
			Beg.	Need to	Cost to
			Inv.	purchase	purchase
	Cloth	7,220	610	6,610	5.25	34,703
	Wood	5,900	800	5,100	7.5	38,250
						72,953

	Cost of direct materials to be used thisperiod
			available from beginning inventory				Total
	Cloth	34,703	3,219				37,922
	Wood	38,250	6,060				44,310
							82,232

	Direct Materials Purchases Budget
	For the Month of June 2015
						Cloth	Wood	Total
	Physical units budget
	To be used in production					7,220	5,900
	Add: target ending direct material inventory					386	295
	Total requirements					7,606	6,195
	Deduct: beginning direct material inventory					610	800
	Purchases to be made					6,996	5,395
	Cost of product					5.25	7.5
	Totals					36,729	40,463	77,192

d.	Direct Manufacturing Labor Cost Budget
	For the Month of June 2015
		Output	Labor hrs	Total	Wage	Total
		units	per unit	hours	rate
	Regular	2,150	5	10,750	15	161,250
	Deluxe	2,950	7	20,650	15	309,750
				31,400		471,000

e.	Manufacturing Overhead Cost Budget for Setup,Processing, and Inspection Activities
	For the Month of June 2015
	Total production		2,150	2,950	5,100
	Total sales		2,000	3,000	5,000
	No. of setup hours		86	118	204
	No. of shipments		50	75	125
	Labor hours		10,750	20,650	31,400

			Setup	Processing	Inspection	Total
	Allocation		Setup hrs	Labor hrs	No. pairs
	Rate		18	1.8	1.35
	No. of Activity		204	31,400	5,100
	Total		3,672	56,520	6,885	67,077

f.	Budgeted Unit Cost of Ending Finished GoodsInventory
	For the Month of June 2015
				Cost per	Regular	Total	Deluxe	Total
				Unit of	Input per		Input per
				Input	Unit		Unit
					Output		Output
	Cloth			5.25	1.3	6.825	1.5	7.875
	Wood			7.5	0	0	2	15
	Direct Manufacturing hours			15	5	75	7	105
	Machine setup			18	0.04	0.72	0.06	1.08
	Processing			1.8	5	9	7	12.6
	Inspection			1.35	1	1.35	1	1.35
	Total					92.895		142.905

	Ending Inventories Budget
	For the Month of June 2015
			Quantity	Cost per		Total
				Unit
	Direct materials
	Cloth		386	5.25	2026.5
	Wood		295	7.5	2212.5	4239
	Finished goods
	Regular		400	92.895	37158
	Deluxe		600	142.905	85743	122901
	Total ending inv.					127140

g.	Cost of Goods Sold Budget
	For the Month of June 2015
						Regular	Deluxe
	Beginning finished goods inventory, Jun 1					23250	92625		115875
	Direct materials used (c)							82232
	Direct manufacturing labor (d)							471000
	Manufacturing overhead (e)							67077
	Cost of goods manufactured								620309
	Cost of goods available for sale								736184
	Deduct ending finished goods inventory, June 30(f)								122901
	Cost of goods sold								613283

h.	Nonmanufacturing Costs Budget
	For the Month of June 2015
	Marketing and general administration				825000	0.08	66000
	Shipping
	(5,000 pairs / 40 pairs per shipment)				125	15	1875
	Total						67875

Again, I just need help with the cash budget question, and thebudgeted income statement and budgeted balance sheet as ofJune.

Thank you!

fuchsiacrow438

1. Which of the following is not part of theoperating budget?

A. Budgeted income statement

B. Sales budget

C. Direct materials budget

D. Cash budget

2. All of the following budgets are prepared by merchandisingcompanies except

A. cost of goods sold, inventoryand purchases.

B. operating expense.

C. direct materials.

D. sales.

3. Pro-Am Audio is a company contracted to DJ private events.Due to a recent increase in bookings, Pro-Am is considering thepurchase of another mobile DJ unit. Pro-Am uses the payback methodto evaluate its investments. The mobile DJ unit will cost $9,000,has a useful life of 12 years, and will generate $3,000 in net cashinflows per year. What is the payback period for the mobile DJunit?

A. 3.00 years

B. 2.63 years

C. 2.20 years

D. 3.37 years

4. How is the direct labor rate variance calculated?

	A. The difference between thestandard labor rate and the actual labor rate
	B. The difference between thestandard labor rate and the actual labor rate multiplied by theactual labor hours used
	C. The difference between thestandard labor hours and the allowable labor hours
	D. The difference between thestandard labor rate and the actual labor rate multiplied by thestandard allowable hours

5. The following data relate to Logan Electric and its LightbulbDivision.

Lightbulb Division sales	$8,500,000
Lightbulb Division operating income	$510,000
Lightbulb Division total assets	$2,500,000
Lightbulb Division current liabilities	$560,000
Corporate target rate of return	16%
Corporate weighted average cost of capital	13%
Corporate effective tax rate	45%

What is the Lightbulb Division's capital turnover?

	A. 3.4
	B. 4.5
	C. 16.7
	D. 4.9

6. A favorable direct labor efficiency variance might indicatethat

A. higher skilled workers were usedthat performed the task faster than expected.

B. higher skilled workers were usedthat performed the task slower than expected.

C. lower skilled workers were paida higher wage than expected.

D. lower skilled workers were paid a lower wage thanexpected.

7. Mockingbird Company expects to sell 5,100 bird perches inJanuary and 9,000 in February for $3 each. What will be the totalsales revenue reflected in the sales budget for those months?

A. January $3,000; February$1,700

B. January $27,000; February$15,300

C. January $15,300; February$27,000

D. January $1,700; February $3,000

8. The ______ capital budgeting method uses accrual accountingincome.

A. internal rate of return

B. accounting rate of return

C. net present value

D. payback

9. The Stallard Corporation manufactures Product X that consumesa large amount of overhead. For the month of October, Stallardproduced 14,200 units of Product X and incurred actual overheadcosts of $269,000. The standard costs developed for Product X byStallard follow:

Standard direct labor hours per unit	4
Standard direct labor rate per hour	$11.00

Standard overhead hours per unit	8
Standard overhead rate per hour	$4.80

What was the total variable overhead variance for Product X inOctober?

	A. $276,280 favorable
	B. $200,840 favorable
	C. $276,280 unfavorable
	D. $200,840 unfavorable

10. Tommy's Toys produces two types of toys: trains and dolls.Tommy's uses stainless steel to manufacture the trains and plasticto manufacture the dolls. Information regarding the usage of steeland plastic for the past year follows:

Product Names	Steel	Plastic
Direct materials information
Standard pounds per unit	2 lb.	1.0 lb.
Standard Price (SP) per pound	$3.00	?
Actual Quantity (AQ) used per unit	3.0 lb.	3.00 lb.
Actual Price (AP) paid for material	$1.75	$2.25
Actual Quantity Purchased (AQP) and used	2,800 lb.	800 lb.
Price variance	?	$1,200 F
Quantity variance	$900 U	?
Flexible budget variance	?	$412 F
Number of units produced	300	525

What is the direct materials flexible budget variance for steelused to manufacture the trains?

	A. $4,400 favorable
	B. $2,600 unfavorable
	C. $2,600 favorable
	D. $4,400 unfavorable

11. Sparky the Electrician specializes in rewiring historichouses. Sparky recently purchased a new wire-pulling device thatwill decrease the time needed to complete each job and increasetotal revenues. The device will cost $5,577 and will increase netcash flows by $1,690 per year. The new device has a useful life of7 years and a residual value of $0. What is the payback period forthe new wire-pulling device?

	A. 3.12 years
	B. 2.80 years
	C. 3.48 years
	D. 3.30 years

12. Sharon Corporation collects 10% in the second monthfollowing sale, 40% in the month following sale, and 40% of amonth's sales in the month of sale. The company has found that 10%of their sales are uncollectible. Budgeted sales for the upcomingfour months are:

August budgeted sales	$280,000
September budgeted sales	$350,000
October budgeted sales	$380,000
November budgeted sales	$240,000

The amount of cash that will be collected in November isbudgeted to be

	A. $316,000
	B. $96,000
	C. $283,000
	D. $216,000

13. Suppose Whole Foods is considering investing inwarehouse-management software that costs $900,000; has $40,000residual value; and should lead to cash cost savings of $180,000per year for its 5-year life. In calculating the ARR, which of thefollowing figures should be used as the equation's denominator?

	A.$220,000
	B. $180,000
	C. $40,000
	D. $900,000

bronzejellyfish275

1. The following data relate to Logan Electric and its LightbulbDivision.

Lightbulb Division sales	$8,500,000
Lightbulb Division operating income	$510,000
Lightbulb Division total assets	$2,500,000
Lightbulb Division current liabilities	$560,000
Corporate target rate of return	16%
Corporate weighted average cost of capital	13%
Corporate effective tax rate	45%

What is the Lightbulb Division's capital turnover?

	A. 3.4
	B. 4.5
	C. 16.7
	D. 4.9

2. A favorable direct labor efficiency variance might indicatethat

A. higher skilled workers were usedthat performed the task faster than expected.

B. higher skilled workers were usedthat performed the task slower than expected.

C. lower skilled workers were paida higher wage than expected.

D. lower skilled workers were paid a lower wage thanexpected.

3. Mockingbird Company expects to sell 5,100 bird perches inJanuary and 9,000 in February for $3 each. What will be the totalsales revenue reflected in the sales budget for those months?

A. January $3,000; February$1,700

B. January $27,000; February$15,300

C. January $15,300; February$27,000

D. January $1,700; February $3,000

4. The ______ capital budgeting method uses accrual accountingincome.

A. internal rate of return

B. accounting rate of return

C. net present value

D. payback

5. The Stallard Corporation manufactures Product X that consumesa large amount of overhead. For the month of October, Stallardproduced 14,200 units of Product X and incurred actual overheadcosts of $269,000. The standard costs developed for Product X byStallard follow:

Standard direct labor hours per unit	4
Standard direct labor rate per hour	$11.00

Standard overhead hours per unit	8
Standard overhead rate per hour	$4.80

What was the total variable overhead variance for Product X inOctober?

	A. $276,280 favorable
	B. $200,840 favorable
	C. $276,280 unfavorable
	D. $200,840 unfavorable

6. Tommy's Toys produces two types of toys: trains and dolls.Tommy's uses stainless steel to manufacture the trains and plasticto manufacture the dolls. Information regarding the usage of steeland plastic for the past year follows:

Product Names	Steel	Plastic
Direct materials information
Standard pounds per unit	2 lb.	1.0 lb.
Standard Price (SP) per pound	$3.00	?
Actual Quantity (AQ) used per unit	3.0 lb.	3.00 lb.
Actual Price (AP) paid for material	$1.75	$2.25
Actual Quantity Purchased (AQP) and used	2,800 lb.	800 lb.
Price variance	?	$1,200 F
Quantity variance	$900 U	?
Flexible budget variance	?	$412 F
Number of units produced	300	525

What is the direct materials flexible budget variance for steelused to manufacture the trains?

	A. $4,400 favorable
	B. $2,600 unfavorable
	C. $2,600 favorable
	D. $4,400 unfavorable

7. Sparky the Electrician specializes in rewiring historichouses. Sparky recently purchased a new wire-pulling device thatwill decrease the time needed to complete each job and increasetotal revenues. The device will cost $5,577 and will increase netcash flows by $1,690 per year. The new device has a useful life of7 years and a residual value of $0. What is the payback period forthe new wire-pulling device?

	A. 3.12 years
	B. 2.80 years
	C. 3.48 years
	D. 3.30 years

8. Sharon Corporation collects 10% in the second month followingsale, 40% in the month following sale, and 40% of a month's salesin the month of sale. The company has found that 10% of their salesare uncollectible. Budgeted sales for the upcoming four monthsare:

August budgeted sales	$280,000
September budgeted sales	$350,000
October budgeted sales	$380,000
November budgeted sales	$240,000

The amount of cash that will be collected in November isbudgeted to be

	A. $316,000
	B. $96,000
	C. $283,000
	D. $216,000

9. Suppose Whole Foods is considering investing inwarehouse-management software that costs $900,000; has $40,000residual value; and should lead to cash cost savings of $180,000per year for its 5-year life. In calculating the ARR, which of thefollowing figures should be used as the equation's denominator?

A.$220,000

B. $180,000

C. $40,000

D. $900,000

10. All of the following budgets are prepared by merchandisingcompanies except

	A.cost of goods sold, inventory andpurchases.
	B. operating expense.
	C. direct materials.
	D. sales.

turquoisewater-buffalo63

ACG 2071 Lecture Notes - Lecture 16: Budget, Cash Flow, Income Statement

Document Summary

Get access

Related Documents

ACG 2071 Lecture Notes - Lecture 18: Fixed Cost, Variable Cost, Sales Territory

ACG 2071 Lecture Notes - Lecture 18: Cost Accounting, Variable Cost

ACG 2071 Lecture Notes - Lecture 17: Key Schedule, Cost Driver, Income Statement

Related Questions