The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are o account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,300 13,300 15,300 14,300 The selling price of the company's product is $22 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 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 $72,800. The company expects to start the first quarter with 2,460 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 guarter is 2.660 units.

The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are o account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,300 13,300 15,300 14,300 The selling price of the company's product is $22 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 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 $72,800. The company expects to start the first quarter with 2,460 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 guarter is 2.660 units.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: ABC company's sales are 20% cash, and 80% credit. For credit sales the company collects 50% one…

A: Total budgeted collection means the amount of cash expected to be collected in a period either from…

Q: Oil & Vinegar Store recorded sales of $180,000 during March. Management expects sales to increase…

A: Gross profit is the difference between total revenue and cost of goods sold. Here, we can identify…

Q: 7) Ehrlich Corporation has projected sales in units for the third quarter of the coming year as…

A: Sales amount :- July = 50,000 x 14 = $700,000 August = 40,000 x 14 = $560,000 September = 60,000 x…

Q: ABC Company's actual unit sales in the current year for January, February, and March were 15, 100,…

A: 1.The Budget unit sales focus on an projected number of units a company expects to sell, It is a…

Q: Lily Company estimates that unit sales will be 11,000 in quarter 1, 15,400 in quarter 2, 16,500 in…

A: Establish the target final inventory for every quarter:25% of Q2 sales times Q1 closing inventory…

Q: Bright Minds Toy Company prepared the following sales budget for the second quarter. Projected sales…

A: The sales budget is prepared to estimate the sales revenue earned during the period. The quarter…

Q: Required: a. Prepare a Schedule of Expected Cash Collections for January and February b. Prepare a…

A: Given in the question: Month Sales January $2,60,000 February $2,70,000…

Q: ABC Company's actual unit sales in the current year for January, February, and march were 15, 200,…

A: The sales budget is prepared to estimate the sales revenue for the current period. The sales revenue…

Q: Prepare a production budget by quarters for the first 6 months of 2025.

A: Budget :A budget refers to a financial plan that outlines expected revenues and expenses over a…

Q: Bright Minds Toy Company prepared the following sales budget for the second quarter. Projected sales…

A: Proforma income statement is that income statement which is prepared on estimation basis. Under…

Q: ABC Company's actual unit sales in the current year for January, February, and March were 16,200,…

A: A budget means forecasts or estimates that are made for a future period of time. The budgeted sales…

Q: Walnut has forecast sales for the next three months as follows: July 4,800 units, August 6,800…

A: Budgeting is an important aspect and part of accounting. Budgeting helps accountant to draw out a…

Q: The marketing department of Jessi Corporation has submitted the following sales forecast for the…

A: The budget is prepared to estimate the requirements for the future period. The production budget is…

Q: Audrey Incorporated has forecast sales to be $223,000 in February, $288,000 in March, $308,000 in…

A: Budgeting anticipates revenue and expenditures for a future period based on the past performance and…

Q: Parker Corporation, which operates on a calendar year, expects to sell 3,000 units in October, and…

A: The budget is prepared at the end of the accounting period to estimate the expected revenue and…

Q: Anderson Labs performs a specialty lab test for local companies for $50 per test. For the upcoming…

A: January February March No. of lab tests 5900 4700 5200 x Sales per test $50 $50 $50 Sales…

Q: Waterway Company estimates that unit sales will be 10, 100 in quarter 1;12, 500 in quarter 2:14,200…

A: The marketing, sales, and finance divisions use the production budget as a point of reference. It…

Q: The Model Company is to begin operations in April. It has budgeted April sales of $70,000, May sales…

A: Cash is the sum of money that a business has on hand. It is often kept in bank accounts since it is…

Q: Blossom Company estimates that 2020 sales will be $40000 in quarter 1, $48000 in quarter 2, and…

A: A merchandise purchases budget is a budgetary arrangement that reports the absolute appraisals…

Q: Atlanta Industries sales budget shows quarterly sales for the next year as follows: Quarter…

A: A production budget outlines the quantity of goods a company plans to manufacture within a specific…

Q: Offenbach & Son has just made its sales forecasts and its marketing department estimates that the…

A: The production budget is prepared to record the estimated units to be produced during the period.

Q: Infinity Inc. has provided the following projected sales units for the next quarter: Projected Sales…

A: The objective of the question is to calculate the budgeted production units for the second month of…

Q: Capstone, Inc. is preparing its budget for the coming year, 2020. The first step is to plan for the…

A: Budgeting: It is a process of planning the work to be performed. Under this process a formal plan is…

Q: Required: 1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a…

A: Sales budget: sales budget is a budget prepared by the company to estimate the expected sales of the…

Q: company's CEO has a meeting with the sales manager to discuss plans to close the gap between the…

A: Budget and Forecast: Budget is the firm plans, policies and activity in the form of a mathematical…

Concept explainers

Master Budget

A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.

Sales Budget and Selling

A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.

Question

Required:
1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole.
2. Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole.
3. Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole.

The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on
account):
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Budgeted unit sales
12,300
13,300
15,300
14,300
The selling price of the company's product is $22 per unit. Management expects to collect 75% of sales in the quarter in which the
sales are made, 20% in the following quarter, and 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 $72,800.
The company expects to start the first quarter with 2,460 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,660 units.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1 Given Information

Step 2 Solution to 1

Step 3 Solution to 2

Step 4 Solution to 3

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Frolic Corporation has budgeted sales and production over the next quarter as follows: July August September Sales in units 70,000 83,000? question mark Production in units 73,250 84, 750 91,750 The company has 17,500 units of product on hand at July 1. 25% of the next month's sales in units should be on hand at the end of each month. October sales are expected to be 97,000 units. Budgeted sales for September would be (in units):
M/s. MNO produces cookies. The company is currently in the process of establishing a master budget on a quarterly basis for this coming fiscal year, which ends December 31. Prior year quarterly unit sales were; 40000 in quarter one, and 45000, 50000, 55000 in the subsequent quarters. Unit sales are expected to increase 25% in quarter one, and 5%, 10%, 5% in the subsequent quarters and each unit is expected to sell for Rs. 6.Required:Prepare Sales Budget
The marketing department of Jessi Corporation submitted the following sales forecast for next year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11,800 12,800 14,800 13,800 Budgeted unit sales The selling price of the company's product is $17 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made and 30% 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 $71,800. The company expects to start the first quarter with 1,770 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 15% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,970 units. Required: 1. Calculate the estimated sales for each quarter and for the year as a whole. 2. Calculate the expected cash collections…
Sunland Company estimates its sales at 180000 units in the first quarter and that sales will increase by 17000 units each quarter over the year. They have, and desire, a 25% ending inventory of finished goods. Each unit sells for $25. 40% of the sales are for cash. 70% of the credit customers pay within the quarter. The remainder is received in the quarter following sale. Cash collections for the third quarter are budgeted at O $5273500. O $3026500. O $4387000. O $6057389.
Austen Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each quarter of the upcoming year are as follows: Austen anticipates selling 222,000 jars with total sales revenue of $267,000 in the first quarter of the year following the year given in the preceding table. Austen has a policy that the ending inventory of jars must be 30% of the following quarter's sales. Total sales Number of jars revenue sold Requirement Prepare a production budget for the year that shows the number of jars to be produced each quarter and for the year in 1st quarter.... $ 185,000 152,500 total. 2nd quarter $ 211,000 180,500 3rd quarter 2$ 257,000 210,000 4th quarter $ 193,000 160,000 ..... Prepare the production budget by first calculating the total units needed, then calculate the units to produce. Austen Foods Production Budget For the Quarters in the Upcoming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Unit sales Plus: Desired ending inventory Total needed Less:…
Blue Company’s budgeted sales and budgeted cost of goods sold for the coming year are $144,440,000 and $90,720,000, respectively. Short-term interest rates are expected to average 10%. If Blue can increase inventory turnover from its present level of 9 times a year to a level of 10 times per year.Compute its expected cost savings for the coming year. Expected Cost Savings
Blue Wave Co. predicts the following unit sales for the coming four months: September, 3,300 units; October, 4,900 units; November, 6,700 units; and December, 7,900 units. The company's policy is to maintain finished goods inventory equal to 50% of the next month's sales. At the end of August, the company had 2,800 finished units on hand. Prepare a production budget for each of the months of September, October, and November. Blue Wave Co. Production Budget September, October and November September Next month's budgeted sales (units) Units to be produced % October % November %
In May 2022, the budget committee of Crane Stores assembles the following data in preparation of budgeted merchandise purchases for the month of June. 1. 2. 3. 4. (a) Expected sales: June $400,000, July $480,000. Cost of goods sold is expected to be 75% of sales. Desired ending merchandise inventory is 30% of the following (next) month's cost of goods sold. The beginning inventory at June 1 will be the desired amount. Compute the budgeted merchandise purchases for June. CRANE STORES Merchandise Purchases Budget $ $
Please solve all requiremetns
Lea Company's sales budget shows the following projections for the year ending Dec. 31, 2021: First quarter 40,000 units Third quarter 50,000 units Second quarter 55,000 units Fourth quarter 45,000 units The quantity of finished goods inventory at the end of each quarter is equal to 40% of the next quarter's budgeted unit sales and is constantly being maintained. What is the total production budget in units for one year ending Dec. 31, 2021 assuming that the estimated sales in units on the first quarter of 2022 is 50,000
Infinity Inc. has provided the following projected sales units for the next quarter: Projected Sales First month Second month Third month Projected sales units 20,000 25,000 30,000 Desired ending inventory is determined to be 12% of the next month’s projected sales. What would be the budgeted production units during the second month of the quarter? Group of answer choices 25,600 units 28,600 units 31,600 units 26,400 units
The marketing department of IKEA Inc. has submitted the following sales forecast for the upcoming fiscal year. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 7,000 6,000 10,000 8,000 The company expects to start the first quarter with 1,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 1,100 units. Each unit requires 0.75 direct labor-hours, and direct laborers are paid $16.00 per labor hour. The variable portion of its predetermined manufacturing overhead rate is $ 4 per direct labor-hour and its total fixed manufacturing overhead is $35,000 per quarter. The only noncash item included in fixed manufacturing overhead is depreciation, which is $8,000 per quarter. The company’s variable selling and administrative expense per unit is $7.50. Fixed selling and administrative expenses include…