Question

1. sed on the following production and sales data of Frixion Co. for March of the current year, prepare the following:

   		Product T		Product X
   Estimated inventory, March 1		28,000	units	20,000	units
   Desired inventory, March 31		32,000	units	15,000	units
   Expected sales volume:
   Territory I		320,000	units	260,000	units
   Territory II		190,000	units	130,000	units
   Unit sales price		$6		$14

   a. Sales budget.

   Frixion Co.
   Sales Budget
   For the Month Ending March 31
   Product and Territory	Unit Sales Volume	Unit Selling Price	Total Sales
   Product T:
   Territory I	fill in the blank 125a71003040f9b_1	$fill in the blank 125a71003040f9b_2	$fill in the blank 125a71003040f9b_3
   Territory II	fill in the blank 125a71003040f9b_4	fill in the blank 125a71003040f9b_5	fill in the blank 125a71003040f9b_6
   Total	fill in the blank 125a71003040f9b_7		$fill in the blank 125a71003040f9b_8
   Product X:
   Territory I	fill in the blank 125a71003040f9b_9	$fill in the blank 125a71003040f9b_10	$fill in the blank 125a71003040f9b_11
   Territory II	fill in the blank 125a71003040f9b_12	fill in the blank 125a71003040f9b_13	fill in the blank 125a71003040f9b_14
   Total	fill in the blank 125a71003040f9b_15		$fill in the blank 125a71003040f9b_16
   Total revenue from sales			$fill in the blank 125a71003040f9b_17

   b. Production budget.

   Frixion Co.
   Production Budget
   For the Month Ending March 31
   	Product T	Product X
   Sales (units)	fill in the blank 9d99f7081067003_1	fill in the blank 9d99f7081067003_2
   	fill in the blank 9d99f7081067003_4	fill in the blank 9d99f7081067003_5
   Total (units) available	fill in the blank 9d99f7081067003_6	fill in the blank 9d99f7081067003_7
   	fill in the blank 9d99f7081067003_9	fill in the blank 9d99f7081067003_10
   Total units to be produced	fill in the blank 9d99f7081067003_11	fill in the blank 9d99f7081067003_12

Answer 1

(a) Sales Budget

Product & Territory	Unit Sales Volume	Unit Selling Price	Total Sales
Product T:
Territory I	320,000	$6	$1,920,000
Territory II	190,000	$6	$1,140,000
Total	510,000		$3,060,000
Product X:
Territory I	260,000	$14	$3,640,000
Territory II	130,000	$14	$1,820,000
Total	390,000		$5,460,000
Total revenue from Sales			$8,520,000

(b) Production Budget

	Product T	Product X
Sales (Units)	510,000	390,000
(+) Desired Inventory, March 31	32,000	15,000
Total (units) available	542,000	405,000
(-) Estimated Inventory, March 1	128,000	20,000
Total Units to be Produced	414,000	385,000