Question: Soprano Co. is in the process of preparing the second quarter budget for 2016, and the following data have been assembled: The company sells a
Soprano Co. is in the process of preparing the second quarter budget for 2016, and the following data have been assembled: The company sells a single product at a selling price of $44 per unit. The estimated sales volume for the next six months is as follows March Apr May 6,100 units 7,500 units 10,000 units June July August 8,100 units 9,100 units 6,100 units Al sales are on account. The compan s collection experience has been that 45% of a month's sales are collected in the month of saio 51 % are cole ed in he month oll in the sale, and 4% are uncollectible t is expected that the net ealizable value o accounts receivable e accounts rece vable less alo ance or uncollectible accounts will be $136,884 on March 31, 2016. Managements policy is to maintain ending finished goods inventory each month at a level equal to 55% of the next month's budgeted sales. The finished goods inventory on March To make one unit finished p dct 4 po nds of materials a requre Management's policy is to have enough next month's estimated usage. The raw materials inventory is expected to be f5,265 pounds on March 31, 2016. The st per pound of raw matenal is $500, and 79% all pu chases are paid in the mont of purchase: e balance for raw material purchases is expected to be $32,475 on March 31, 2016 materials on hand at the end ofeach month to equal 43% of the ai der s pad n the lo ing month. The accounts ay ble Required a. Prepare a sales budget in units and dollars, by month and in total, for the second quarter (April, May, and June) of 2016 April Expected sales in units Selling price per unit Total sales
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
