Scarborough Corporation manufactures and sells two products: D-One and D-Two. In July 2018, Scarborough budget department gathered the following data to prepare budgets for 2019: 2019 Projected Sales: Product D-One |D-Two Units 60,000 40,000 Price $165 $250 2019 Inventories in Units: Product D-One D-Two Expected Target January 1, 2019 20,000 8,000 December 31, 2019 25,000 9,000 The following direct materials are used in the two products: Direct material A Amount Used per Unit D-One 4 Unit D-Two kilogram kilogram each 5 3 1 Projected data for 2019 with respect to direct materials are as follows: Expected Inventories January 1, 2019 32,000 kg 29,000 kg 6,000 units Direct material Anticipated Purchase price $12 Target Inventories December 31, 2019 36,000 kg 32,000 kg 7,000 units A B 3 Projected direct labour requirements and rates for 2019 are as follows: Product D-One D- Two Hours per unit 2 3 Rate per hour $12 16 Based on the preceding projections and budget requirements for D-One and D-Two, prepare the following budgets for 2019. Required: a) Sales budget b) Production budget c) Direct material purchases budget (in quantities)

Scarborough Corporation manufactures and sells two products: D-One and D-Two. In July 2018, Scarborough budget department gathered the following data to prepare budgets for 2019: 2019 Projected Sales: Product D-One |D-Two Units 60,000 40,000 Price $165 $250 2019 Inventories in Units: Product D-One D-Two Expected Target January 1, 2019 20,000 8,000 December 31, 2019 25,000 9,000 The following direct materials are used in the two products: Direct material A Amount Used per Unit D-One 4 Unit D-Two kilogram kilogram each 5 3 1 Projected data for 2019 with respect to direct materials are as follows: Expected Inventories January 1, 2019 32,000 kg 29,000 kg 6,000 units Direct material Anticipated Purchase price $12 Target Inventories December 31, 2019 36,000 kg 32,000 kg 7,000 units A B 3 Projected direct labour requirements and rates for 2019 are as follows: Product D-One D- Two Hours per unit 2 3 Rate per hour $12 16 Based on the preceding projections and budget requirements for D-One and D-Two, prepare the following budgets for 2019. Required: a) Sales budget b) Production budget c) Direct material purchases budget (in quantities)

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

Use the information below for Mandy Corporation to answer the question that follow. Mandy Corporation sells a single product. Budgeted sales for the year are anticipated to be 696,000 units, estimated beginning inventory is 106,000 units, and desired ending inventory is 89,000 units. The quantities of direct materials expected to be used for each unit of finished product are given below.Material A: 0.50 lb. per unit @ $0.71 per poundMaterial B: 1.00 lb. per unit @ $1.89 per poundMaterial C: 1.20 lb. per unit @ $0.84 per poundThe dollar amount of Material B used in production during the year is
You have been presented with the following information by the Budget Committee of the organization in which you work: Sales forecast January – April 2020 Details Study lamps Accent lights Expected selling price per unit $300 $500 Sales Volume forecast: January 2 000 units 1 000 units February 2 500 units 1 500units March 3 000 units 1 000 units April 2 000 units 1 200 units Additional information: (i) Beginning inventories: study lamps 300 units; accent lights 200 units. (ii) The ending inventory for each product at the end of each month is to be maintained at 20% of the budgeted sales for the next month. (iii) To make one study lamp, four (4) units of raw material lumber are used, while five (5) units of raw material aluminum are used to make one accent lights. Required: The Sales Budget for both products for January to March 2020. The Direct Material usage budget.
Fisher-Price manufactures two products, Bassinet and Swing, which use raw materials, pins and clips. One bassinet uses 4 units of pins and 3 units of clips. One swing uses 2 units of pins and 6 units of clips. One pin is expected to cost $7 and one clip is expected to cost $5. Sales and finished goods inventory budget for the year 2020 are as follows: Bassinets Swings Budgeted sales 5,000 units Budgeted sales 7.000 units Opening inventory 1,000 units Opening inventory 2,000 units Closing inventory 600 units Closing inventory 800 units Selling price $400 Selling price $300 Raw material inventory budget for the year 2020 are as follows: Pins Clips Opening inventory 2,400 units Opening inventory 3,300 units Closing inventory 500 units Closing inventory 600 units The warehouse and stores managers have suggested that a provision should be made for damages and deterioration of items held in store, as…
The production department of Headstrong Company has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 8,100 9,100 7,100 6,100 In addition, the beginning raw materials inventory for the first quarter is budgeted to be 1,950 kilograms and the beginning accounts payable for the first quarter are budgeted to be $3,490. Each unit requires 3.1 kg of raw material that costs $2.50 per kilogram. Management desires to end each quarter with an inventory of raw materials equal to 10% of the following quarter’s production needs. The desired ending inventory for the fourth quarter is 2,325 kilograms. Management plans to pay for 80% of raw material purchases in the quarter acquired and 20% in the following quarter. Each unit requires 0.6 direct labour-hours, and direct labour-hour workers are paid $19.5 per hour. Required: 1-a. Prepare the company's direct…
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…
Sunland Inc. is preparing its annual budgets for the year ending December 31, 2025. Accounting assistants furnish the data shown below. Product JB 50 Product JB 60 Sales budget: Anticipated volume in units 480,000 240,000 Unit selling price $30 $35 Production budget: Desired ending finished goods units 36,000 18,000 Beginning finished goods units 30,000 12,000 Direct materials budget: Direct materials per unit (pounds) 2 3 Desired ending direct materials pounds 36,000 12,000 Beginning direct materials pounds 48,000 18,000 Cost per pound $3 $4 Direct labor budget: Direct labor time per unit 0.4 0.6 Direct labor rate per hour $12 $12 Budgeted income statement: Total unit cost $13 $20 An accounting assistant has prepared the detailed manufacturing overhead budget and the selling and administrative expense budget. The latter shows selling expenses of $672,000 for product JB 50 and $432,000 for product JB 60, and administrative expenses of $648,000 for product JB 50 and $408,000 for product…
Westport Company is preparing its master budget for May. Use the estimates provided 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 E and W estimate sales of 50,000 and 100,000 units, respectively, and the unit selling price is $35? b. If the beginning finished goods inventory is an estimated 6,000 units and the desired ending inventory is 8,000 units, how many units should be produced?Answer units c. What dollar amount of materials should be purchased at $2.50 per pound if each unit of product requires 2.5 pounds and beginning and ending materials inventories should be 12,000 and 13,500 pounds, respectively. d. How much direct labor cost should be incurred if each unit produced requires 0.5 hours at an hourly rate of $16? e. How much manufacturing overhead should be incurred if fixed manufacturing overhead is $45,000 and variable manufacturing…
1. ABC Company is budgeting sales of 110,000 units of Product R for the month of November 2023. Production of one unit of R requires two units of Material A and three units of Material B. Actual inventory units on November 1 and budgeted inventory units on November 30 are as follows: Actual inventory November 1 Budgeted inventory at November 30 20,000 10,000 18,000 25,000 22,000 24,000 How many units of Material A is ABC planning to purchase during November 2023? Show your solution. 2. Ashton Appliances Inc. is preparing a budget for 2024 by quarters. Budget data appear as follows: Product R Material A Material B 1st quarter 2nd quarter 3rd quarter 4th quarter 1st quarter, 2025 Budgeted sales Materials purchases Beginning materials P860,000 940,000 990,000 960,000 $280,000 360,000 400,000 300,000 P75,000 65,000 50,000 45,000 40,000 Direct labor is budgeted at P140,000 each quarter with factory overhead estimated at 200 percent of direct labor costs. Selling and general expenses are…
Use the information below for Mandy Corporation to answer the question that follow. Mandy Corporation sells a single product. Budgeted sales for the year are anticipated to be 643,000 units, estimated beginning inventory is 105,000 units, and desired ending inventory is 84,000 units. The quantities of direct materials expected to be used for each unit of finished product are given below.Material A: 0.50 lb. per unit @ $0.61 per poundMaterial B: 1.00 lb. per unit @ $2.37 per poundMaterial C: 1.20 lb. per unit @ $0.86 per poundThe dollar amount of Material C used in production during the year is a.$577,714 b.$770,285 c.$706,094 d.$641,904
Vibrant Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget: Rumble Thunder Estimated inventory (units), June 1 258 70 Desired inventory (units), June 30 296 61 Expected sales volume (units): North Region 3,250 3,650 South Region 5,200 4,500 Unit sales price $95 $185 a. Prepare a sales budget. Vibrant Inc. Sales Budget For the Month Ending June 30 Unit Unit Total Sales Selling Sales Volume Price Product and Area Model Rumble: North Region South Region Total Model Thunder: North Region South Region Total Total revenue from sales b. Prepare a production budget. Vibrant Inc. Production Budget For the Month Ending June 30 Units Units Model Model Rumble Thunder Expected units to be sold Total units required Total units to be produced
Softlan Limited manufactures one product known as Eco1. The following information relates to the preparation of the budget for the year to 31 March 2020: 1) Sales budget details for product Eco1: Expected selling price per unit: RM100. Expected sales in units: 10,000. All sales are on credit terms. 2) Eco1 requires 5 units of raw material E and 10 units of raw material C. E is expected to cost RM3 per unit and C RM4 per unit. All goods are purchased on credit terms. 3) Two departments are involved in producing Eco1: machining and assembly. The following information is relevant: Direct labour per unit of product (hours) Direct labour rate per hour RM Machining 1.00 6 Assembling 0.50 8 4) The finished production overhead costs are expected to amount to RM100,000. 5) At 1 April 2019, 800 units of Eco1 are expected to be in stock at a value of RM52,000, 4,500 units of raw material E at a value of RM13,500, and 12,000 units of raw materials at a value of RM48,000. Stocks of both finished…