Foundational 15/ethics challange

jack_unit_5_homework.xls

The Foundational 15


1	Unit sales
	Selling price per unit
	Total sales
			July
2.	June sales
	July sales
	Total Cash collections
3	July sales
	Percent collected
	Accounts Receivable
			July
4	Budgeted sales in units
	Add desired ending inventory
	Total needs
	Less beginning inventory
	Required production
5.	Required production in units
	Raw materials needed per unit
	Raw materials needed to meet production
	Add desired ending raw materials inventory
	Total raw materials needs
	Less beginning raw materials inventory
	Raw materials to be purchased
6	Raw materials to be purchased (pounds)
	Cost per pound
	Cost of raw material purchases
			July
7	June purchases
	July purchases
	Total cash disbursements
8	July purchases
	Percent unpaid
	Accounts Payable
9	Ending raw materials inventory (pounds)
	Cost per pound
	Raw material inventory balance
			July
10	Required production in units
	Direct labor hours per unit
	Total direct labor-hours needed
	Direct labor cost per hour
	Total direct labor cost
		Quantity	Cost	Per	Total
11	Direct materials			pound
	Direct labor			hour
	Manufacturing overhead			hour
	Unit product cost
12	Ending finished goods inventory in units
	Unit product cost
	Ending finished goods inventory
13	Unit sales
	Unit product cost
	Estimated cost of goods sold
	The estimated gross margin for July:
	Total sales
	Cost of goods sold
	Estimated Gross margin
			July
14	Budgeted unit sales
	Variable selling and administrative
	expense per unit
	Total variable expense
	Fixed selling and adminisrative expenses
	Total selling and administrative expenses
15	Gross margin
	Selling and administrative expenses
	Net operating income

&L&F

	Please write your answers in the boxes provided. The text will wrap and you may expand the box as needed. Thanks!
1.
2.
3.