23. Ironman Inc. is a retail distributor for MZB-33 computer hardware and related software. Ironman prepares annual sales forecasts, of which the first six months of the coming year are presented below: Hardware units Hardware dollars Software Total sales January 140 $420,000 $180,000 $600,000 February 130 390,000 160,000 550,000 March 100 300,000 120,000 420,000 April 50 150,000 100,000 250,000 May 60 180,000 120,000 300,000 June 100 300,000 200,000 500,000 Cash sales account for 25% of Ironman's total sales, 30% of the total sales are paid by bank credit card, and the remaining 45% are on open account (Ironman's own charge accounts). The cash and bank credit card sale payments are received in the month of the sale. Bank credit card sales are subject to a 4% discount, which is deducted immediately. The cash receipts for sales on open account are 70% in the month following the sale and 28% in the second month following the sale, the remaining are uncollectible.Ironman's month-end inventory requirements for computer hardware units are 30% of the next month's sales. The units must be ordered two months in advance due to long lead times quoted by the manufacturer.Required: 1. Calculate the cash that Ironman can expect to collect during April. Show all of your calculations. 2. Determine the number of computer hardware units that should be ordered in January. Show all of your calculations.
23.
Ironman Inc. is a retail distributor for MZB-33 computer hardware and related software. Ironman prepares annual sales
|
|
Hardware units |
Hardware dollars |
Software |
Total sales |
|
January |
140 |
$420,000 |
$180,000 |
$600,000 |
|
February |
130 |
390,000 |
160,000 |
550,000 |
|
March |
100 |
300,000 |
120,000 |
420,000 |
|
April |
50 |
150,000 |
100,000 |
250,000 |
|
May |
60 |
180,000 |
120,000 |
300,000 |
|
June |
100 |
300,000 |
200,000 |
500,000 |
Cash sales account for 25% of Ironman's total sales, 30% of the total sales are paid by bank credit card, and the remaining 45% are on open account (Ironman's own charge accounts). The cash and bank credit card sale payments are received in the month of the sale. Bank credit card sales are subject to a 4% discount, which is deducted immediately. The cash receipts for sales on open account are 70% in the month following the sale and 28% in the second month following the sale, the remaining are uncollectible.
Ironman's month-end inventory requirements for computer hardware units are 30% of the next month's sales. The units must be ordered two months in advance due to long lead times quoted by the manufacturer.
Required:
1. Calculate the cash that Ironman can expect to collect during April. Show all of your calculations.
2. Determine the number of computer hardware units that should be ordered in January. Show all of your calculations.
Step by step
Solved in 2 steps
