This is spreadsheet where answers are intended to go so if you could please detail how to get answers and the entire process it would be appreciated!

Freese, Inc. is in the process of preparing the fourth quarter budget for 2013, and the following data have been assembled: -->The company sells a single product at a selling price of $60 per unit. The estimated sales volume for the six months is as following September October November December January February Units 13,000 12,000 14,000 20,000 9,000 10,000 -->All sales are on account. The company's collection expereience has been that 32% of a month's sales are collected in the month of sale, 64% in the month following the sale, and 4% are uncollectible. According to the budget, the net realizable value of accounts receivable (i.e, accounts receivable less allowance for uncollectible accounts) is expected to be $499,200 on September 30, 2013. --> Management's policy is to maintain ending finished goods inventory each month at a level equal to 40% of hte next month's budgeted sales. The finished goods inventory on September 30, 2013, is expected to be 4,800 units. --> To make one unit of finsihed product, 5 pounds of raw material are required. management's policy is to have enough materials on hand at the end of each monthy to equal 30% of the next month's estimated usage. the raw materials inventory is expected to be 19,200 pound s on September 30, 2013. --> The cost per pound of material is $4 and 70% of all purchases are paid for in the month of purchase; the remainder is paid in the following month. the accounts payable for raw material purchases is expected to be $75,960 on September 30, 2013.

in the "Analysis worksheet" complete the basic problem requirements. complete by entering appropriate amounts or formulas in shaded worksheet cells: All the other parts except this one have been completed!

e. prepare a schedule of cash payments for materials, by month and in total for the fourth quarter of 2013

Complete the Modeling a. Sales Budget Quarter Ended December 31, 2013 September October November December Total January February Expected sales in units Selling price per unit Total Sales b. Cash Collections from: Quarter Ended December 31, 2013 Sales %Collected October November December Total September sales: $ October sales:$ October sales: $ November sales: $ November sales: $ December Sales: $ Total cash collections c. Production Budget Quarter Ended December 31, 2013 Finished Goods %Budgeted October November December Total Janua Beginning Inventory: Units to be produced: Goods available for sale Desired ending inventory Quantity of goods sold: 4,800 148001 d. Materials Purchases Budget October November December Total January Units to be produced: Pounds required for each unit Total pounds used in production (4,800) Quarter Ended December 31, 2013 %Budgeted | October November December Total Beginning Inventory: Purchases of materials Materials available for use: Desired ending inventory Total pounds used in production 19,200 19,200 e. Cash Payments for October Novemberecember Total Purchases of materials Cost per pound of raw material: Total cost of raw material purchases: (19,200) Quarter Ended December 31, 2013 Purchases % Paid | October November , December Total 75,960 September Net AP. October purchases: October purchases: $ November purchases: S November purchases: $ December purchases s $75,960 Total cash payments 75,960