EXERCISES: BUDGETING with PROBABILITY ANALYSIS1. Production & Inventory BudgetDMD Company has budgeted sales at P 100,000 and expects a profit of 10% of the sales. Expenses areestimated as follows: selling 10% of sales; administrative = 15% of sales. Labor is expected to be 40%of the total manufacturing costs. Factory overhead is to be applied at 75% of direct labor costs.Inventories are to be as follows:=January 1P 4,0002,5005,000MaterialsWork-in-processFinished goodsREQUIRED: Determine the budgeted amount for:A) Cost of goods soldB) Total manufacturing costC)Factory overheadD) Materials purchases2. Sales & Accounts Receivable BudgetPast collections experienced by BJS Company indicate that 60% of the sales billed in a month are collectedduring the month of sales, 30% are collected in the following month, and 10% are collected in the secondfollowing month. The following are the projected sales for next year:Other budgeted estimates are:JanuaryFebruaryMarchAprilMayP 480,000P 420,000REQUIRED: Determine the following:A) Budgeted collections during the month of March.Budgeted collections during the month of May.B)C) Projected accounts receivable balance on April 1.D) Projected accounts receivable balance on June 1.P 500,000P 550,000P 600,000December 31P 1,5007,50010,0003. Merchandise Purchases BudgetCIT Merchandising has budgeted the following sales for the 2nd quarter of 2021:April P 123,500May156,000June208,000REQUIRED: Determine the projected amount for:A) Merchandise purchases in April.All merchandises are to sell at its invoice cost plus 30% mark-up.Beginning inventories of each month are budgeted at 40% of that particular month's projected costof goods sold.B) Merchandise purchases in May.

Since you have posted multiple questions, as per the guidelines only the first question will be…

EXERCISES: BUDGETING with PROBABILITY ANALYSIS 1. Production & Inventory Budget DMD Company has budgeted sales at P 100,000 and expects a profit of 10% of the sales. Expenses are estimated as follows: selling = 10% of sales; administrative = 15% of sales. Labor is expected to be 40% of the total manufacturing costs. Factory overhead is to be applied at 75% of direct labor costs. Inventories are to be as follows: Materials January 1 P 4,000 2,500 5,000 Work-in-process Finished goods REQUIRED: Determine the budgeted amount for: A) Cost of goods sold B) Total manufacturing cost December 31 P 1,500 7,500 10,000 C) Factory overhead D) Materials purchases

EXERCISES: BUDGETING with PROBABILITY ANALYSIS 1. Production & Inventory Budget DMD Company has budgeted sales at P 100,000 and expects a profit of 10% of the sales. Expenses are estimated as follows: selling = 10% of sales; administrative = 15% of sales. Labor is expected to be 40% of the total manufacturing costs. Factory overhead is to be applied at 75% of direct labor costs. Inventories are to be as follows: Materials January 1 P 4,000 2,500 5,000 Work-in-process Finished goods REQUIRED: Determine the budgeted amount for: A) Cost of goods sold B) Total manufacturing cost December 31 P 1,500 7,500 10,000 C) Factory overhead D) Materials 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

Assume a merchandising company provides the following information from its master budget for the month of May: $ 120,000 $ 80,000 $ 35,000 Sales Cost of goods sold Selling and administrative expenses What is the budgeted gross margin? Multiple Choice $75.000 $165,000 $5.000 $40.000
Produce 101 Company has required you to prepare a cash budget on the basis of following Month AmountFebruary RM74,000March RM38,000April RM49,000May RM74,000June RM65,000 information:i. The company has observed that 35% of its sales is cash basis and the balance is collectedin the following month.ii. The company’s raw materials cost is 70% of sales. Usually purchases are made 1 (ONE)month before the month of sales and paid cash. Salaries and lease payments areRM15,000 and RM12,000 respectively.iii. The company plans to make a cash purchase of a new van for RM60,000 and sell itsmarketable securities for RM90,000 in May.iv. The company's cash balance as of February 28, 2020 will be RM25,000. Excess cash willbe used to retire short-term borrowing (if any). Assume that the interest rate on short-termborrowing is 1% per month. The company must have a minimum cash balance ofRM15,000 at the beginning of each month. Construct cash budget for March, April and May 2020.
Direct manufacturing labour budget Manufacturing overhead budget Ending inventories budget (direct materials and finished goods) Cost of goods sold budget For each budget, prepare by product (Premium and De Luxe) and in total.
Preparing an Overhead Budget Patrick Inc. makes industrial solvents. Budgeted direct labor hours for the first 3 months of the coming year are: January 13,140 February 12,300 March 15,075 The variable overhead rate is $0.60 per direct labor hour. Fixed overhead is budgeted at $2,580 per month. Required: Prepare an overhead budget for the months of January, February, and March, as well as the total for the first quarter. Do not include a multiplication symbol as part of your answer. Round total variable overhead and total overhead to the nearest dollar. Patrick Inc. Overhead Budget For the Coming First Quarter Overhead: January February March Total Total direct labor hrs Variable overhead rate Total variable overhead $4 Add: Fixed overhead Total overhead
Assume a company's sales budget for July estimates 15,000 units sold. The variable selling and administrative expense used for budgeting purposes is $4.00 per unit sold. The total budgeted fixed selling and administrative expense for July is $80,000 including depreciation of $15,000. What is the total budgeted selling and administrative expense for July? Multiple Choice $120,000 $155,000 $125,000 $140,000
Surf Inc. has prepared the sales forecast as shown below: Description Month 1 Month 2 Month 3 Month 4 Sales Forecast 25,000.00 27,000.00 29,000.00 23,000.00 Prepare the production budget and show the required production for Months 1-3 Beg Inv Month 1 3,500.00 Required Ending Inventory 15% of the next months budgeted sales Description Month 1 Month 2 Month 3
Preparing a Direct Labor Budget Patrick Inc. makes industrial solvents. Planned production in units for the first three months of the coming year is: January 40,000 February 55,000 March 60,000 Each drum of industrial solvent takes 0.3 direct labor hours. The average wage is $18.40 per hour. Required: Prepare a direct labor budget for the months of January, February, and March, as well as the total for the first quarter. Do not include a multiplication symbol as part of your answer. Patrick Inc. Direct Labor Budget For the Coming First Quarter Direct Labor Budget: January February March Total Units to be produced Direct labor hrs per unit Total direct labor hrs Wage rate Direct labor cost
Saved La Campany produces hand toos Budgeted sales for March are 10,700 units. Beginning finished goods inventory in March is budgeted to be 2,300 nd endrg frished goods Inventory is budgeted to be 2,000 units. How many units will be produced in March? L Doice .00 S00 30
Give answer as per required
Down Under Products' sales budget for the next four months is as follows: April May June July Unit Sales 76,000 85,000 116,000 93,000 The company wants its ending inventory levels to equal 15% of the following month's unit sales. The inventory at the end of March was 11,400 units. Required: Prepare a production budget, by month and in total, for the second quarter. Budgeted unit sales Total needs Required production in units Down Under Products, Limited Production Budget April 77,350 77,350 77,350 May 89,650 89,650 89,650 June 112,550 112,550 112,550 Quarter 0 0
5. A business has the following budgeted financial data for next year: January February Production units 8,000 9,000 Direct labor hours per unit 0.5 0.5 Straight time man hours 4,800 4,100 Straight time wage rate per hour $16 $16 Overtime wage rate (time and a half) $24 $24 Assume the business plans to pay all straight time man hours budgeted regardless of demand. A. Determine the total labor cost for January based on the data above. B. Determine the total labor cost for February based on the data above.
Zoom Pte Ltd has prepared the following budget for the next three months: January February March Sales in units 16,000 21,000 20,000 Production in units 17,000 19,000 18,000 One kg of material is required for each finished unit. The inventory of materials at the end of each month should equal 20% of the following month's production needs. Purchases of raw materials for February would be budgeted to be: Question 18 options: 1) 19,000 kg 2) 19,200 kg 3) 23,000 kg 4) 18,800 kg