Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

From A to E please, it's due soon. Problem 14-26 (Algo) Sales, production, purchases, and cash budgets LO 14-4, 14-5, 147 Freese Incorporated is in

image text in transcribed

From A to E please, it's due soon.

Problem 14-26 (Algo) Sales, production, purchases, and cash budgets LO 14-4, 14-5, 147 Freese Incorporated is in the process of preparing the fourth quarter budget for 2022 , and the following data have been assembled: - The company sells a single product at a price of $64 per unit. The estimated sales volume for the next six months is as follows: - All sales are on account. The company's collection experience has been that 30% of a month's sales are collected in the month of sale, 68% are collected in the month following the sale, and 2% are uncollectible. It is expected that the net realizable value of accounts receivable (i.e., accounts receivable less allowance for uncollectible accounts) will be \$396,032 on September 30, 2022. - Management's policy is to maintain ending finished goods inventory each month at a level equal to 30% of the next month's budgeted sales. The finished goods inventory on September 30, 2022, is expected to be 2,520 units. - To make one unit of finished product, 5 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 17,640 pounds on September 30, 2022. - The cost per pound of raw material is $2, 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 $26,586 on September 30, 2022. Required: a. Prepare a sales budget in units and dollars, by month and in total, for the fourth quarter (October, November, and December) of 2022. b. Prepare a schedule of cash collections from sales, by month and in total, for the fourth quarter of 2022. c. Prepare a production budget in units, by month and in total, for the fourth quarter of 2022. d. Prepare a materials purchases budget in pounds, by month and in total, for the fourth quarter of 2022. e. Prepare a schedule of cash payments for materials, by month and in total, for the fourth quarter of 2022. Complete this question by entering your answers in the tabs below. Prepare a sales budget in units and dollars, by month and in total, for the fourth quarter (October, November, and December) of 2022

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting And Reporting A Global Perspective

Authors: Herve Stolowy, Yuan Ding, Luc Paugam

6th Edition

147376730X, 9781473767300

More Books

Students also viewed these Accounting questions