Scholastic Furniture, Incorporated, manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company's Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division's sales manager. April May June 15,500 desk-and-chair sets 17,500 desk-and-chair sets 20,500 desk-and-chair sets Each desk-and-chair set requires 11 board feet of pine planks and 1.5 hours of direct labor. Each set sells for $50. Pine planks cost $.50 per board foot, and the division ends each month with enough wood to cover 10 percent of the next month's production requirements. The division incurs a cost of $22 per hour for direct-labor wages and fringe benefits. The division ends each month with enough finished-goods inventory to cover 20 percent of the next month's sales. Required: Complete the following budget schedules. 1. Sales budget. 2. Production budget (in sets). 3. Raw-material purchases. 4. Direct-labor budget.

Scholastic Furniture, Incorporated, manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company's Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division's sales manager. April May June 15,500 desk-and-chair sets 17,500 desk-and-chair sets 20,500 desk-and-chair sets Each desk-and-chair set requires 11 board feet of pine planks and 1.5 hours of direct labor. Each set sells for $50. Pine planks cost $.50 per board foot, and the division ends each month with enough wood to cover 10 percent of the next month's production requirements. The division incurs a cost of $22 per hour for direct-labor wages and fringe benefits. The division ends each month with enough finished-goods inventory to cover 20 percent of the next month's sales. Required: Complete the following budget schedules. 1. Sales budget. 2. Production budget (in sets). 3. Raw-material purchases. 4. Direct-labor budget.

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

Rahul
s Scholastic Furniture, Incorporated, manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company's Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division's sales manager. April May June 14,500 desk-and-chair sets 16,500 desk-and-chair sets 19,500 desk-and-chair sets Each desk-and-chair set requires 12 board feet of pine planks and 1.3 hours of direct labor. Each set sells for $45. Pine planks cost $.50 per board foot, and the division ends each month with enough wood to cover 10 percent of the next month's production requirements. The division incurs a cost of $25 per hour for direct-labor wages and fringe benefits. The division ends each month with enough finished-goods inventory to cover 20 percent of the next month's sales. Required: Complete the following budget schedules. 1. Sales budget. 2.…
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: Budgeted monthly absorption costing income statements for April–July are: April May June July Sales $ 690,000 $ 860,000 $ 570,000 $ 470,000 Cost of goods sold 483,000 602,000 399,000 329,000 Gross margin 207,000 258,000 171,000 141,000 Selling and administrative expenses: Selling expense 87,000 106,000 68,000 47,000 Administrative expense* 48,500 65,600 42,200 45,000 Total selling and administrative expenses 135,500 171,600 110,200 92,000 Net operating income $ 71,500 $ 86,400 $ 60,800 $ 49,000 *Includes $29,000 of depreciation each month. Sales are 20% for cash and 80% on account. Sales on account are…
Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: Budgeted sales (all on account) April May June Total $ 360,000 $ 560,000 $ 220,000 $ 1,140,000 From past experience, the company has learned that 30% of a month's sales are collected in the month of sale, another 60% 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 $290,000, and March sales totaled $320,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? > Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of expected cash collections from sales, by month…
Use the following information for questions 5 & 6: Dilly Farm Supply is in a small town in the rural west. Data regarding the store's operations follow: • Sales are budgeted at $290,000 for November, $310,000 for December, and $210,000 for January. • Collections are expected to be 65% in the month of sale and 35% in the month following the sale. • The cost of goods sold is 80% of sales. • The company desires to have an ending merchandise inventory at the end of each month equal to 70% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase. • Other monthly expenses to be paid in cash are $21,100. ● Monthly depreciation is $21,000. • Ignore taxes. Assets Cash A/R Inventory PP&E, net of $624,000 accumulated depreciation Total assets Liabilities and Stockholders' Equity A/P Common Stock Retained Earnings Total liabilities and stockholders' equity 5. 6. Balance Sheet October 31 a. b. Expected cash collections in December are: C. d. a. b.…
Milo Company manufactures beach umbrellas. The company is preparing budgets for the third quarter and assembled the following information: The Marketing Department estimated unit sales as follows for the remainder of the year:July 33,000 October 23,000August 76,000 November 9,500September 45,000 December 10,000The selling price of the beach umbrellas is $15 per unit. All sales are on account. Based on past experience, sales are collected in the following pattern:30% in the month of sale65% in the month following sale5% uncollectibleSales for June totaled $375,000. The company maintains finished goods inventories equal to 15% of the following month’s sales. This requirement will be met at the end of June.Each beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires ending inventory of Gilden equal to 50% of the following month’s production needs. The inventory of Gilden on hand at the…
A department store has budgeted cost of goods sold for October of $30,000 for its women's coats. Management also wants to have $8,000 of its women's coats in inventory at the end of the month to prepare for the winter season. Beginning inventory for October was $6,000. What dollar amount of women's coats should be purchased to meet the above objectives?
Milo Company manufactures beach umbrellas. The company is preparing budgets for the third quarter and assembled the following information: The Marketing Department estimated unit sales as follows for the remainder of the year:July 33,000 October 23,000August 76,000 November 9,500September 45,000 December 10,000The selling price of the beach umbrellas is $15 per unit. All sales are on account. Based on past experience, sales are collected in the following pattern:30% in the month of sale65% in the month following sale5% uncollectibleSales for June totaled $375,000. The company maintains finished goods inventories equal to 15% of the following month’s sales. This requirement will be met at the end of June.Each beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires ending inventory of Gilden equal to 50% of the following month’s production needs. The inventory of Gilden on hand at the…
Vishnu
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.
Beauty Spa & Co. manufactures a specialised luxury spa that is supplied to five-star hotels around the country. The owner provides you with the following information to prepare its 1st quarter budget: July, August, and September. Budgeted sales are as follows: Month Sales ($) Units Sold May 25,000 250 June 28,000 280 July 30,000 300 August 40,000 400 September 35,000 350 October 37,000 370 Additional information: i) Purchases are budgeted at $5.00 per unit and are paid for in full in the month after purchase. ii) Closing inventory must equal 50% of the next month’s sales. iii) Sales (which are all on credit) are collected as follows: 60% in the month of sale; 30% in the month after the sale; 5% in the second month after the sale. iv) The balance in the bank account as of 30 June is $10,000. Required (show your workings for each question): Prepare a purchases budget (in units and $) for the 1st…
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