Question

Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do = = ). General Calibri B I 11 . Font - A A . .A. Wrap Text Merge & Center. U $ . % * 3 Alignment Number Clipboard R14 4. A . B C D G H nter the last 4 digits of your student ID number 4 Name/s: 7 Save this file in EXCEL FORMAT as: P2 Lastname 8 Round all answers to whole numbers 9 Do not change rows or colums on this spreadsheet. Input areas are in yellow 10 NOTE: Formulas amd cell refenremces are REQUIRED for Requirements 1-7. Highest Lowest other than o 12 Perfect Pots, Inc. makes large, outdoor decorative flower pots that have the look of clay but are made from a polyresin 13 material that is much more durable. The controller for the company is working on the budget for the coming fiscal year, which 14 begins April 1. 16 Requirement 1: 18 Multiply the highest digit from your student ID number shove by 100 and enter in the box below 19 Sales in units for April are expected to be: Page 1 21 Sales are expected to increase by 10% each month through August Bach ocells for 150 22 Complete the Sales Budget for April - June and the quarter in total. 23 Sales Budget April 25 Sales in units 900 990 1,089 2.979 26 Price per unit $ 150 $ 150 $ 150 $ 150 27 Total sales dollars S 135,000 $ 148,500 $ 163,350 $ 446,850 July 1.197.90 150.00 179,685 $ $ august 1,317.69 150.00 197,654 29 Requirment 2: 31 Multiply your lowest digit (other than o) from your student ID number above by 10 and insert for the % below: 33 The company wants to have (per above) of the flower pots that are expected to be sold 34 the following month on hand at the end of each month. There were 80 flower pots on hand at the end of March 36 Complete the Production Budget for April - June and the quarter in total. Total 2.979 38 Production Budget 39 Sales in units 40 Desired ending inventory 41 Total required 42 Beginning inventory Sheet1 April 900 1 98 1,098 O Hint: You will need to calculate July's sales in units in order to calculate the desired ending inventory for June. July 1198 263.54 1.461.44 990 218 1,208 198 240

Answer 1

7			Contribution income statement
						Total	Per unit
	Sales				a	446850	150
	Variable costs:
	Direct materials					66659	20
							(4*5)
	Direct labor					69049	22
							(1*22)
	Variable overhead					9416	3
	Variable selling expense					5958	2
	Total variable costs				b	151082	47
	Contribution margin				c=a-b	295768	103
	Fixed costs:
	Manufacturing overhead					8200
	Administrative expenses					3300
	Total fixed costs				d	11500
	Operating income				e=c-d	284268
8	Actual selling price per unit=Actual sales in $/Actual units sold=279300/1900=$ 147
	Actual variable cost per unit sold=Total variable cost/Actual units sold=79800/1900=$ 42
	1)	Activity variance for sales revenue=Budgeted selling price per unit*(Actual units sold-Budgeted units sold)
		If the answer is positive,variance is favorable.Otherwise unfavorable.
		Activity variance for sales revenue=150*(1900-2979)=-161850=$ 161850 Unfavorable
	2)	Revenue variance for sales revenue=Actual units sold*(Actual selling price per unit-Budgeted selling price per unit)
		If the answer is positive,variance is favorable.Otherwise unfavorable.
		Revenue variance for sales revenue=1900*(147-150)=-5700=$ 5700 Unfavorable
	3)	Activity variance for total variable costs=Budgeted variable cost per unit*(Budgeted units sold-Actual units sold)
		If the answer is positive,variance is favorable.Otherwise unfavorable.
		Activity variance for total variable costs=47*(2979-1900)=$ 50713 Favorable
	4)	Spending variance for total variable costs=Actual units sold*(Budgeted variable costs per unit-Actual variable costs per unit)
		If the answer is positive,variance is favorable.Otherwise unfavorable.
		Spending variance for total variable costs=1900*(47-42)=$ 9500 Favorable