The following are the sales forecast of Avril Furniture Company for the upcoming fiscalyear:Year 2Year 3Quarter 110,000Quarter 315,000Quarter 2Quarter 423,000Quarter 130,000Budgeted unit salesPast experience has shown that the ending inventory for each quarter should be equal to10% of the next quarter's sales in units. The company expect to start the first quarter with4,000 units.Two pounds of material A are required for each unit produced. The company has a policyof maintaining a stock of material A on hand at the end of each quarter equal to 25% of thenext quarter's production needs for material A. Fourth quarter ending of materials isestimated as 8,000 pounds and a total of 12,000 pounds of material A are on hand to startthe year. The cost of material A is $3 per pound.Required:a. Prepare a production budget showing the number of units to be produced each quarterand for the year in totak proď th.b. Prepare Avril's Direct Material Budget and calculate direct materials dollar amount ofpurchases by quarter and for the year in total16,000

Budgets are the estimated amount that is based on future sales, it helps in analyzing the current…

Answered: The following are the sales forecast of…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 1R: Ranger Industries has provided the following information at June 30: Other information: Average...

See similar textbooks

Similar questions

If the sales forecast estimates that 50,000 units of product will be sold during the following year, should the factory plan on manufacturing 50,000 units in the coming year? Explain.
Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.
Refer to Cornerstone Exercises 2.2 and 2.3. Next year, Pietro expects to produce 50,000 units and sell 49,300 units at a price of 12.50 each. Beginning inventory of finished goods is 42,500, and ending inventory of finished goods is expected to be 34,000. Total selling expense is projected at 26,000, and total administrative expense is projected at 134,000. Required: 1. Prepare an income statement in good form. Be sure to include the percent of sales column. 2. What if the cost of goods sold percentage for the past few years was 65 percent? Explain how management might react.
Barnstormer sells airplane accessories for $20 each. It expects sales of 120,000 units in quarter 1 and a 7% increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year.
Rehydrator makes a nutrition additive and expects to sell 3,000 units in January, 2,000 in February, 2,500 in March, 2,700 in April. and 2,900 in May. The required ending inventory is 20% of the next months sales, and the beginning inventory on January 1 was 600 units. Prepare a production budget for the first four months of the year.
A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000
Croy Incorporated has the following projected sales for the next five months: Month April May June July August Sales in Units 3,530 3,815 4,530 4,120 3,990 Croy's finished goods inventory policy is to have 50 percent of the next month's sales on hand at the end of each month. Direct materials cost $2.80 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month's production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,673 pounds. Required: 1. Determine budgeted production for April, May, and June. 2. Determine budgeted cost of direct materials purchased for April and May. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Determine budgeted production for April, May, and June. Note: Do not round your intermediate calculations and round your final answers to the nearest whole number. June Budgeted Production (Units) April May
The sales forecast for birdhouses built by Splish Enterprises follows. Beginning inventory for the year is expected to be 8,000 birdhouses, and the production manager prefers to maintain an ending inventory of 15% of the next quarter's sales. Quarter Number of Birdhouses First 8,000 Second 24,000 Third 29,000 Fourth 40,000
Croy Incorporated has the following projected sales for the next five months: Sales in Month April Units 3,590 May 3,840 June 4,520 4,130 3,990 July August Croy's finished goods inventory policy is to have 50 percent of the next month's sales on hand at the end of each month. Direct materials cost $3.50 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month's production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,715 pounds. Required: 1. Determine budgeted production for April, May, and June. 2. Determine budgeted cost of direct materials purchased for April and May.
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,850 May 3,875 June 4,260 July 4,135 August 3,590 Croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. Direct materials cost $3.10 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,865 pounds. Required: 1. Determine budgeted production for April, May, and June.2. Determine budgeted cost of materials purchased for April and May.
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,850 May 3,875 June 4,260 July 4,135 August 3,590 Croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. Direct materials cost $3.10 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,865 pounds. Required: 1. Determine budgeted production for April, May, and June.2. Determine budgeted cost of materials purchased for April and May. (round answers to 2 decimal places)

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Principles of Cost Accounting

Accounting

ISBN:

9781305087408

Author:

Edward J. Vanderbeck, Maria R. Mitchell

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS