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. Production budget (in sets). 3. Raw-material purchases.

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. Production budget (in sets). 3. Raw-material purchases.

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

Lock Tight, Inc., produces outside doors for installation on homes. The following information was gathered to prepare budgets for the upcoming year beginning January 1. 6,500 doors 720 doors 680 doors 40,000 pounds 80,000 pounds 6,000 square feet 4,000 square feet 4 per pound Sales forecast in units Finished goods inventory, January 1 Target finished goods inventory, December 31 Raw materials inventory-steel, January 1 Target inventory-steel, December 31 Raw materials inventory-glass, January 1 Target inventory-glass, December 31 Budgeted purchase price-steel Budgeted purchase price-glass 2 per square foot The manufacture of each door requires 20 pounds of steel and 6 square feet of glass. a. Prepare the production schedule in units for Lock Tight. b. Using the production schedule, develop the direct materials purchase budgets for steel and glass. Complete this question by entering your answers in the tabs below. Required A Required B Using the production schedule, develop the direct…
Annie's Homemade is preparing a planning budget for August. Its budgeted revenue per serving is $5.00. It has identified two cost drivers-number of servings and number of labor-hours. The company expects to sell 10,800 servings and to staff 700 employee labor-hours in August. Data concerning the company's cost formulas are shown below: Ingredients expense Salaries and wages expense Franchise fee Credit card processing fees Utilities expense $ 300 Rent expense $ 3,000 Equipment depreciation expense $1,750 Other expenses $4,200 Required: Prepare a planning budget for August. Budgeted servings Budgeted labor-hours Revenue Expenses: Fixed Cost Cost per Per Month $ 7,000 Ingredients expense Salaries and wages expense Franchise fee Credit card processing fees Utilities expense Rent expense Equipment depreciation expense Other expenses Total expense Net operating income $ Serving $ 1.25 $ 0.25 $ 0.09 $ 0.02 0 Cost per Labor-Hour $ 8.00
Shamrock Shades operates in mall kiosks throughout the southwestern United States. Shamrock purchases sunglasses from bulk discounters and sells the sunglasses in the mall kiosks. Shamrock is in the process of budgeting for the coming year and has projected sales of $310,000 for January, $390,000 for February, $550,000 for March, and $590,000 for April. Shamrock’s desired ending inventory is 30 percent of the following month’s cost of goods sold. Cost of goods sold is expected to be 20 percent of sales. Required: Compute the required purchases for each month of the first quarter (January–March).
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 $ 400,000 May $ 600,000 June $ 190,000 Total $ 1,190,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 $330,000, and March sales totaled $360,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? Complete this question by entering your answers in the tabs below. Required 1 Required 2 What is the accounts receivable balance on June 30th? Total accounts receivable at June 30
Rahul
Janet Lawerence the controller for Toy Bike Maker Inc is preparing a production budget for the year. The company's policy is 1. maintain a finished goods inventory equal to one-half of the following month's sales. 2. Sales of 7,000 toy bikes are budgeted for April. 3. Complete the monthly production budget for the first quarter March 6,000 4. Sales in units Add desired units of ending finished goods inventory Desired total units Less desired units of beginning finished goods inventory Total production units January February 5,000 4,000 2,000 7,000 ? 4,500 ? ? i t ?
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: April May June Total Budgeted sales (all on account) $410,000 $610,000 $210,000 $1,230,000 From past experience, the company has learned that 25% of a month’s sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $340,000, and March sales totaled $370,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?
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…
Becker Bikes manufactures tricycles. The company expects to sell 500 units in May and 630 units in June. Beginning and ending finished goods for May are expected to be 170 and 135 units, respectively. June's ending finished goods are expected to be 145 units. Compute Becker's production budget for May and June. Budgeted production (units) May June
Lozano Company manufactures T-shirts printed with tourist destination logos. The following table shows sales prices and projected sales volume for the summer months: Prepare a sales budget for Lozano Company for the three months .
The budget director of Gourmet Grill Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for March is summarized as follows: a. Estimated sales for March by sales territory: Maine: Backyard Chef 350 units at $800 per unit Master Chef 200 units at $1,400 per unit Vermont: Backyard Chef 400 units at $825 per unit Master Chef 240 units at $1,500 per unit New Hampshire: Backyard Chef 320 units at $850 per unit Master Chef 200 units at $1,600 per unit b. Estimated inventories at March 1: Direct materials: Grates 320 units Stainless steel 1,700 lb. Burner subassemblies 190 units Shelves 350 units Finished products: Backyard Chef 30 units Master Chef 36 units c. Desired inventories at March 31: Direct materials: Grates 300 units Stainless steel 1,500 lb. Burner subassemblies 210 units…