Reference no: EM13515565
Sales, production, purchases, and cash budgets Soprano Co. is in the process of preparing the second quarter budget for 2010, and the following data have been assembled:
- The company sells a single product at a selling price of $40 per unit. The estimated sales volume for the next six months is as follows:
|
March
|
6,000 units
|
|
April
|
7,000 units
|
|
May
|
10,000 units
|
|
June
|
8,000 units
|
|
July
|
9,000 units
|
|
August
|
6,000 units
|
All sales are on account. The company's collection experience has been that 40% of a month's sales are collected in the month of sale, 55% are collected in the month following the sale, and 5% are uncollectible. It is expected that the net realizable value of accounts receivable (i.e., accounts receivable less allowance for uncollectible accounts) will be $132,000 on March 31, 2010.
- Management's policy is to maintain ending finished goods inventory each month at a level equal to 50% of the next month's budgeted sales. The finished goods inventory on March 31, 2010, is expected to be 3,500 units.
- To make one unit of finished product, 3 pounds of materials are required. Management's policy is to have enough materials on hand at the end of each month to equal 40% of the next month's estimated usage. The raw materials inventory is expected to be 10,200 pounds on March 31, 2010.
- The cost per pound of raw material is $6.00, and 80% of all purchases are paid for in the month of purchase; the remainder is paid in the following month. The accounts payable balance for raw material purchases is expected to be $26,280 on March 31, 2010.
Required:
a. Prepare a sales budget in units and dollars, by month and in total, for the second quarter (April, May, and June) of 2010.
b. Prepare a schedule of cash collections from sales, by month and in total, for the second quarter of 2010.
c. Prepare a production budget in units, by month and in total, for the second quarter of 2010.
d. Prepare a materials purchases budget in pounds, by month and in total, for the second quarter of 2010.
e. Prepare a schedule of cash payments for materials, by month and in total, for the second quarter of 2010.
|
Explain the difference between an american option
: Explain the difference between an American option and a European option.
|
|
Depict a second energy curve
: Suppose that the reaction A---> products is exothermic and has an activation barrier of 75kJ/mol. Sketch an energy diagram showing the energy of the reaction as a function of the progress of the reaction. Draw a second energy curve showing the eff..
|
|
Obtain the magnitude of the force on the wire
: A horizontal magnetic field of 2.0×10?4 T is at an angle of 25 to the direction of the current in a straight, horizontal wire 75 cm long. what is the magnitude of the force on the wire
|
|
Explain the new thermodynamic variable that is used
: Find a corresponding criterion for processes at constant V and T. The new thermodynamic variable that is used to express this criterion is called the Helmholtz free energy
|
|
Prepare a schedule of cash collections from sales
: Prepare a sales budget in units and dollars, by month and in total, for the second quarter (April, May, and June) of 2010 and prepare a schedule of cash collections from sales, by month and in total, for the second quarter of 2010.
|
|
Explain titration of the acid solution requires
: A 1.00-g solid sample containing a mixture of NaCl and H3C6H5O7, a triprotic acid, is dissolved in 15 ml of water. Titration of the acid solution requires 25.40 mL of 0.1598 M NaOH solution to reach the endpoint.
|
|
How much electric charge passes through the starter motor
: The starter motor of a car engine draws an electric current of 42.0 A from the battery. The copper wire to the motor is 5.70 mm in diameter and 1.36 m long. How much electric charge passes through the starter motor
|
|
Prepare a cash budget for july
: Prepare a cash budget for July - what is your advice to management of PrimeTime Sportswear?
|
|
Define the energy required to dissociate the h2 molecule
: The energy required to dissociate the H2 molecule to H atoms is 432 KJ/mol H2. If the dissociation of an H2 molecule were accomplished by the absorption of a single photon whose energy was exactly the quantity required , that would be its wavelend..
|