CompUSA Incorporated sells computer hardware. It also markets related software and software-support services. The company prepares annual forecasts for sales, of which the first six month of 2022 are given below.

In a typical month, total sales are broken down as follows: cash sales, 30%; VISA credit card sales, 65%; and 5% open account (the companys own charge accounts). For budgeting purposes, assume that cash sales plus bank credit card sales are received in the month of sale; bank credit card sales are subject to a 3% processing fee, which is deducted daily at the time of deposit into CompUSAs cash account with the bank. Cash receipts from collection of accounts receivable typically occur as follows: 21% in the month of sale, 50% in the month following the month of sale, and 26% in the second month following the month of sale. The remaining receivables generally turn out to be uncollectible.

CompUSAs month-end inventory requirements for computer hardware units are 30% of the following months estimated sales. A one-month lead time is required for delivery from the hardware distributor. Thus, orders for computer hardware units are generally placed by CompUSA on the 25th of each month to ensure availability in the store on the first day of the month needed. These units are purchased on credit, under the following terms: n/45, measured from the time the units are delivered to CompUSA. Assume that CompUSA takes the maximum amount of time to pay its invoices. On average, the purchase price for hardware units runs 60% of selling price.

CompUSA Incorp
Forecasted sales (unit and dollars)
Jan - june
	number of units	hardware sales	software support sales	total revenue
january	138	358800	149000	507800
Feb	148	384800	169000	553800
mar	90	234000	139000	373000
apr	100	260000	134000	394000
may	128	332800	159000	491800
june	138	358800	149000	507800
totals	742	1929200	899000	2828200

Required:

Q1. The company is looking at the number of hardware units to order on January 25.

- Determine the estimated number of units to be ordered?

- Calculate the dollar cost (per unit and total) for these units?

-Cash planning in this line of business is critical to success. Management feels that the assumption of selling price per unit ($2,800) is firmat least for the foreseeable future. Also, it is comfortable with the 30% rate for end-of-month inventories. It is not so sure, however, about (a) the Cost of Goods Sold (CGS) rate (because of the state of flux in the supplier market) and (b) the level of predicted sales in March 2022. Discussions with marketing and purchasing suggest that three outcomes are possible for each of these two variables, as follows:

Outcome	March Sales		CGS%
Optimistic	100	units	55%
Expected	90	units	60
Pessimistic	80	units	65

The preceding outcomes are assumed to be independent, which means that there are nine possible combinations (3 3). You are asked to conduct a sensitivity analysis to determine the range of possible cash outflows for April 10, under different combinations of the above. Assume, for simplicity, that sales volume for April is fixed.

Complete the following table:

	march sales			cash payment
scenario	units	cgs%		april 10
1	100	55	%	?
2	100	60	%	?
3	100	65	%	?
4	90	55	%	?
5	90	60	%	?
6	90	65	%	?
7	80	55	%	?
8	80	60	%	?
9	80	65	%	?
		Maximum	=	?
		Minimum	=	?
		Range	=	?