The marketing department of Jessi Corporation submitted the following sales forecast for next year (all sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The marketing department of Jessi Corporation submitted the following sales forecast for next year (all sales are on account): Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12,500 13,500 15,500 14,500 The selling price of the company's product is $24 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made and 20% in the following quarter; 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in the first quarter, is $73,200. The company expects to start the first quarter with 2,500 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 2,700 units. Required: 1. Calculate the estimated sales for each quarter and for the year as a whole. 2. Calculate the expected cash collections for each quarter and for the year as a whole. 3. Calculate the required production in units of finished goods for each quarter and for the year as a whole. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Calculate the estimated sales for each quarter and for the year as a whole. Total sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Calculate the expected cash collections for each quarter and for the year as a whole. Total cash collections 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Calculate the required production in units of finished goods for each quarter and for the year as a whole. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Required production in units Year The marketing department of Jessi Corporation submitted the following sales forecast for next year (all sales are on account): Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12,500 13,500 15,500 14,500 The selling price of the company's product is $24 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made and 20% in the following quarter; 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in the first quarter, is $73,200. The company expects to start the first quarter with 2,500 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 2,700 units. Required: 1. Calculate the estimated sales for each quarter and for the year as a whole. 2. Calculate the expected cash collections for each quarter and for the year as a whole. 3. Calculate the required production in units of finished goods for each quarter and for the year as a whole. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Calculate the estimated sales for each quarter and for the year as a whole. Total sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Calculate the expected cash collections for each quarter and for the year as a whole. Total cash collections 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Calculate the required production in units of finished goods for each quarter and for the year as a whole. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Required production in units Year
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Consider two polluting firms with cost functions C j (x j ,e j ). The inverse demand function is P(X). Firms engage in negotiations about the permit allocation and a transfer price in a first stage...
-
Knitpix Products is a division of Parker Textiles Inc. During the coming year, it expects to earn income of $310,000 based on sales of $3.45 million; without any new investments, the division will...
-
If the waveform in Fig. 7.116(a) is applied to the circuit of Fig. 7.116(b), find v(t). Assume v(0) = 0. i, (A) 6
-
Presented below are selected financial data from The Boeing Company 2015 annual report. Using the ratio definitions from Exhibit 4.6, calculate the following ratios: receivable turnover, receivable...
-
During 2016 and 2017, Agatha Corp. completed the following transactions relating to its bond issue. The corporations fiscal year is the calendar year. 2016 Jan. 1 Issued $300,000 of 10-year, 6...
-
Make-or-Buy Decision, Alternatives, Relevant Costs Each year, Giada Company produces 18,000 units of a component part used in tablet computers. An outside supplier has offered to supply the part for...
-
The managers of Soup Inc. consider the opportunity to open a new soup restaurant in a small college town. As of today, the best estimate of the value of the future cash flows (in present value terms)...
-
Complete common -size statements (balance sheets) using the data below. You will be required to create a spreadsheet in MS Excel to display the statements (balance sheets).? compare and contrast the...
-
Bob believes he can save $175,000 to use when his son begins college in 12 years. Assume Bob currently has no savings. If he saves $1,000 per month, what is the estimated annual investment rate...
-
A home office performs the payroll functions for Segments 1, 2, and 3 and incurs a total payroll expense of $500,000. The contractor allocates this indirect cost using a base of the number of...
-
An insulated beaker with negligible mass contains liquid water with a mass of 0.205 kg and a temperature of 83.9 C Part A How much ice at a temperature of -10.0 C must be dropped into the water so...
-
'Future Search' is a method for a community or organization to create a shared vision for its future. 'Future Search' generates all stakeholders' commitment and energy for action. Involved...
-
A 4 cylinder 4 stroke petrol engine with bore equal 10 cm and stroke of 8 cm and with a clearance volume of 75 cm3 is running at 3200 rpm and attached to a dynamometer produces 200 N.m. the mass of...
-
1. Following are information about Alhadaf Co. Cost incurred Inventory Purchases Sales Adverting expense Salary Expense Depreciation Beginning Inventory Ending Inventory Amount 118,000 350.000 90,000...
-
Arthur Jansky and Edward Thayer are partners, each with $27,000.00 equity in an existing business. The partners share equally in all changes in equity. On March 1 of the current year, Dean McGee is...
-
On July 1 of the current year, Roy Hatfield and Michelle Allen form a partnership. The partners share equally in all changes in equity. The partnership assumes the assets and liabilities of Roy's...
-
Helen Cole, her husband, and her son were partners in a business. Mrs. Cole's husband died, leaving his equity in the partnership to Mrs. Cole. Mrs. Cole and her son plan to form a new partnership...
Study smarter with the SolutionInn App