Question

1.) Weightless Inc. produces a small and large version of its popular electronic scale. The anticipated unit sales for the scales by sales region are as follows:

	Bath Scale		Gym Scale
East Region unit sales	23,600		38,900
West Region unit sales	25,500		26,800
Total	49,100		65,700

The finished goods inventory estimated for October 1 for the Bath and Gym scale models is 1,500 and 2,000 units, respectively. The desired finished goods inventory for October 31 for the Bath and Gym scale models is 1,100 and 2,200 units, respectively.

Prepare a production budget for the Bath and Gym scales for the month ended October 31.

WEIGHTLESS INC.
Production Budget
For the Month Ending October 31
	Units Bath Scale	Units Gym Scale
Expected units to be sold
Total units required
Total units to be produced

2.) Lorenzo’s Frozen Pizza Inc. has determined from its production budget the following estimated production volumes for 12'' and 16'' frozen pizzas for September:

	Units
	12" Pizza		16" Pizza
Budgeted production volume	13,900		20,700

Three direct materials are used in producing the two types of pizza. The quantities of direct materials expected to be used for each pizza are as follows:

		12" Pizza		16" Pizza
Direct materials:
	Dough	0.80	lb. per unit	1.50	lb. per unit
	Tomato	0.50		0.70
	Cheese	0.70		1.30

In addition, Lorenzo’s has determined the following information about each material:

	Dough		Tomato		Cheese
Estimated inventory, September 1	640	lb.	200	lb.	360	lb.
Desired inventory, September 30	670	lb.	190	lb.	390	lb.
Price per pound	$1.30		$2.40		$3.00

Prepare September's direct materials purchases budget for Lorenzo’s Frozen Pizza Inc. When required, enter unit prices to the nearest cent.

Lorenzo’s Frozen Pizza Inc.
Direct Materials Purchases Budget
For the Month Ending September 30
	Dough	Tomato	Cheese	Total
Units required for production:
12" pizza
16" pizza
Total pounds required
Total units to be purchased
Unit price	x $	x $	x $
Total direct materials to be purchased	$	$	$	$

3.) MatchPoint Racket Company manufactures two types of tennis rackets, the Junior and Pro Striker models. The production budget for March for the two rackets is as follows:

	Junior	Pro Striker
Production budget	6,900 units	21,800 units

Both rackets are produced in two departments, Forming and Assembly. The direct labor hours required for each racket are estimated as follows:

	Forming Department	Assembly Department
Junior	0.2 hour per unit	0.4 hour per unit
Pro Striker	0.3 hour per unit	0.65 hour per unit

The direct labor rate for each department is as follows:

Forming Department	$14 per hour
Assembly Department	$9 per hour

Prepare the direct labor cost budget for March.

MatchPoint Racket Company
Direct Labor Cost Budget
For the Month Ending March 31
	Forming Department	Assembly Department
Hours required for production:
Junior
Pro Striker
Total hours required
Hourly rate	x$	x$
Total direct labor cost	$	$

4.) Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows:

May	$220,000
June	330,000
July	430,000

All sales are on account. 51 percent of sales are expected to be collected in the month of the sale, 38% in the month following the sale, and the remainder in the second month following the sale.

Prepare a schedule indicating cash collections from sales for May, June, and July.

Furry Friends Supplies Inc.
Schedule of Collections from Sales
For the Three Months Ending May 31
	May	June	July
May sales on account:
Collected in May
Collected in June
Collected in July
June sales on account:
Collected in June
Collected in July
July sales on account:
Collected in July
Total cash collected	$	$	$

Answer 1

1) Production budget

WEIGHTLESS INC.
Production Budget
For the Month Ending October 31
	Units Bath Scale	Units Gym Scale
Expected units to be sold	49,100	65,700
Add: desired ending inventory	1,100	2,200
Total units required	50,200 [49,100+1,100]	67,900[65,700+2,200]
Less: Beginning Inventory	(1,500)	(2,000)
Total units to be produced	48,700[50,200-1,500]	65,900[67,900-2,000]

We can answer only one question per post, please upload other questions separately.

Please upvote if you find this helpful. Incase of query please comment.