Pine Tree Furniture Industries manufactures wooden dining chairs. The selling price of the wooden dining chairs is $14 per unit. The company is preparing detailed budgetsfor the third quarter (Third quarter includes July, August and September) and fourth quarter (Fourth quarter includes October, November and December) and has assembledthe following information to assist in the budget preparation (see below tables). Calculate the estimated sales (in dollars) for the third quarter.Estimated unit sales for the next several monthMonthJulyAugustSeptemberOctoberNovemberDecemberUnits100200150200200300All sales are on account (i.e., on credit). These sales on account are usually collected in the following pattern:30%65%5%in the month of salein the month following saleUncollectible

Estimated sales (in dollars) for the third quarter = 6,300Explanation:Multiply the estimated unit…

Answered: Pine Tree Furniture Industries…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Wala Incorporated bases its selling and administrative expense budget on the number of units sold. The variable selling and administrative expense is $3.70 per unit. The budgeted fixed selling and administrative expense is $30,360 per month, which includes depreciation of $3,630. The remainder of the fixed selling and administrative expense represents current cash flows. The sales budget shows 3,100 units are planned to be sold in July. Required: Prepare the selling and administrative expense budget for July. Fixed selling and administrative expense Total selling and administrative expense Cash disbursements for selling and administrative expenses $ $ $ July 3,600 4.00 14,400 14,400 14,400
Yarbrough Company manufactures T-shirts printed with tourist destination logos. The following table shows sales prices and projected sales volume for the summer months: (Click the icon to view the data.) Prepare a sales budget for Yarbrough Company for the three months. - X Data Table Yarbrough Company Sales Budget June, July, and August Projected Sales in Units June July August Total T-Shirt Sizes Sales Price June July August Youth T-Shirts Youth $ 7 575 500 525 Adult-Regular T-Shirts Adult-regular 17 625 900 825 Adult-oversized 18 400 500 475 Adult-Oversized T-Shirts Total sales Print Done Activate Windows Enter any number in the edit fields and then click Check Answer.
Budget Preparation Collins Company is preparing its master budget for April. Use the given estimates to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement.) a. What should total sales revenue be if territories A and B estimate sales of 10,000 and 13,000 units, respectively, and the unit selling price is $43? $ b. If the beginning finished goods inventory is an estimated 2,000 units and the desired ending inventory is 3,000 units, how many units should be produced? c. What dollar amount of material should be purchased at $4 per pound if each unit of product requires 3 pounds and beginning and ending materials inventories should be 5,000 and 4,000 pounds, respectively? $ d. How much direct labor cost should be incurred if each unit produced requires 1.5 hours at an hourly rate of $14? e. How much manufacturing overhead should be incurred if fixed manufacturing overhead is $52,000 and variable manufacturing…
Atlantic Surf manufactures surfboards. The company's budgeted sales units for the next three months is shown below. Company policy is to maintain finished goods inventory equal (in units) to 40% of the next month's unit sales. As of June 30, the company has 1,760 finished surfboards in inventory. Budgeted sales units July 4,400 August 5,500 September 3,300 Prepare the production budget for the months of July and August. ATLANTIC SURF Production Budget Budgeted sales units Add: Desired ending inventory Desired ending inventory units Total required units Units to be produced July 0 August 0
I need the working solution for the cash balance at the beginning month. Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $130,000 $156,000 $205,000 Manufacturing costs 55,000 67,000 74,000 Selling and administrative expenses 46,000 47,000 78,000 Capital expenditures _ _ 49,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $10,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid…
Garden Sales, Incorporated, sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense* Total selling and administrative expenses Net operating income *Includes $17,000 of depreciation each month. April $ 550,000 385,000 165,000 75,000 42,500 117,500 $ 47,500 May $ 750,000 525,000 225.000 95,000 56,800 151,800 $ 73,200 June $ 450,000 315,000 135,000 56,000 35,000 91,000 $ 44,000 July $ 350,000 245,000 105,000 35,000 33,000 68,000 $ 37,000 b. Sales are 20% for cash and 80% on account. c. Sales on account are collected over a three-month period with…
Silver Company makes a product with peak sales in May of each year. Its sales budget for the second quarter is given below: April May June Total Budgeted sales (all on account) $300,000 $500,000 $200,000 $1,000,000 The company estimates 20% of a month's sales are collected in the month of sale, another 70% are collected in the month following sale, and the remaining 10% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $230, 000, and March sales totaled $260,000. Required: Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. What is the accounts receivable balance on June 30th?
Ruiz Company provides the following budgeted sales for the next four months. The company wants to end each month with ending finished goods inventory equal to 30% of next month's budgeted unit sales. Finished goods inventory on April 1 is 153 units. Prepare a production budget for the months of April, May, and June. Budgeted sales units. April 510 Budgeted sales units Add: Desired ending inventory Next period budgeted sales units Ratio of inventory to future sales Budgeted beginning inventory units Total required units Units to produce May 590 RUIZ COMPANY Production Budget April June 540 590 30% July 630 May 540 30% June 630 30%
Wala Incorporated bases its selling and administrative expense budget on the number of units sold. The variable selling and administrative expense is $3.70 per unit. The budgeted fixed selling and administrative expense is $30,360 per month, which includes depreciation of $3,630. The remainder of the fixed selling and administrative expense represents current cash flows. The sales budget shows 3,100 units are planned to be sold in July. Required: Prepare the selling and administrative expense budget for July.
Collins Company is preparing its master budget for April. Use the given estimates to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement.) a. What should total sales revenue be if territories A and B estimate sales of 10,000 and 13,000 units, respectively, and the unit selling price is $43? b. If the beginning finished goods inventory is an estimated 2,000 units and the desired ending inventory is 3,000 units, how many units should be produced? c. What dollar amount of material should be purchased at $4 per pound if each unit of product requires 3 pounds and beginning and ending materials inventories should be 5,000 and 4,000 pounds, respectively? d. How much direct labor cost should be incurred if each unit produced requires 1.5 hours at an hourly rate of $14? e. How much manufacturing overhead should be incurred if fixed manufacturing overhead is $52,000 and variable manufacturing overhead is $2.50 per…
Ivanhoe Company, a retailer of camping supplies has budgeted activity for January using the following data: January cash sales January credit sales Collections from December credit sales Selling and administrative costs (paid in month of purchase) Depreciation expense Merchandise Inventory, January 1 Merchandise Inventory, January 31 Cost of goods sold is 30% of Cooper's selling price All purchases are paid in cash Credit sales are collected 60% in the month of sale, 30% in the following month, and 10% is deemed uncollectible What is Ivanhoe's budgeted cash disbursements for January? Total January disbursements $ $59,000 386,000 155,000 59,000 22,000 199,000 211,000
Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the coming year. The income statements for the last four quarters follow: Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income First Quarter Second Quarter Third Quarter Fourth Quarter $ 174,000 $ 264,000 87,000 132,000 87,000 132,000 $ 214,000 107,000 107,000 21,400 17,400 26,400 $ 69,600 $ 85,600 $ 105,600 Historically, cost of goods sold is about 50 percent of sales revenue. Selling and administrative expenses are about 10 percent of sales revenue. Fred Arvada, the chief executive officer, told Mr. Long that he expected sales next year to be 10 percent for each respective quarter above last year's level. However, Rita Banks, the vice president of sales, told Mr. Long that she believed sales growth would be only 5 percent. Required a. Prepare a pro forma income statement including quarterly budgets for the coming year using Mr. Arvada's estimate. b. Prepare…

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS