Concept explainers
Operating Budget, Comprehensive Analysis
Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below.
January | 10,000 |
February | 10,600 |
March | 13,500 |
April | 16,000 |
May | 18,500 |
The following data pertain to production policies and manufacturing specifications followed by Ponderosa:
- Finished goods inventory on January 1 is 900 units. The desired ending inventory for each month is 20 percent of the next month’s sales.
- The data on materials used are as follows:
Direct Material Per-Unit Usage Unit Cost Part #K298 2 $4 Part #C30 3 7 Inventory policy dictates that sufficient materials be on hand at the beginning of the month to satisfy 30 percent of the next month’s production needs. This is exactly the amount of material on hand on January 1.
- The direct labor used per unit of output is one and one-half hours. The average direct labor cost per hour is $20.
Overhead each month is estimated using a flexible budget formula. (Activity is measured in direct labor hours.)Fixed Cost
ComponentVariable Cost
ComponentSupplies $ — $1.00 Power — 0.20 Maintenance 12,500 1.10 Supervision 14,000 — Depreciation 45,000 — Taxes 4,300 — Other 86,000 1.60 - Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Activity is measured in units sold.)
Fixed Costs Variable Costs Salaries $ 88,500 — Commissions — $1.40 Depreciation 25,000 — Shipping — 3.60 Other 137,000 1.60 - The unit selling price of the wiring harness assembly is $110.
- In February, the company plans to purchase land for future expansion. The land costs $68,000.
- All sales and purchases are for cash. The cash balance on January 1 equals $62,700. The firm wants to have an ending cash balance of at least $25,000. If a cash shortage develops, sufficient cash is borrowed to cover the shortage and provide the desired ending balance. Any cash borrowed must be borrowed in $1,000 increments and is repaid the following month, as is the interest due. The interest rate is 12 percent per annum.
Required:
Prepare a monthly operating budget for the first quarter with the following schedules:
9.
Sales | $fill in the blank 60ebc0fdefe6fb3_1 |
Less: Cost of goods sold | fill in the blank 60ebc0fdefe6fb3_2 |
Gross margin | $fill in the blank 60ebc0fdefe6fb3_3 |
Less: Selling and administrative expense | fill in the blank 60ebc0fdefe6fb3_4 |
Income before income taxes | $fill in the blank 60ebc0fdefe6fb3_5 |
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps
- How do I prepare the selling and administrative expense budget for the quarter ended March 31, 20X1?arrow_forwardBudget 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…arrow_forwardRequired information Miami Solar manufactures solar panels for industrial use. The company budgets production of 4,200 units (solar panels) in July and 4,600 units in August. Each unit requires 4 pounds of direct materials, which cost $6 per pound. The company’s policy is to maintain direct materials inventory equal to 40% of the next month’s direct materials requirement. As of June 30, the company has 6,720 pounds of direct materials in inventory, which complies with the policy. Prepare a direct materials budget for July. MIAMI SOLAR Direct Materials Budget For Month Ended July 31 Budget production (units) 4,200 Materials needed for production (lbs.) Total materials requirements (lbs.) Materials to be purchased (lbs.) Budgeted cost of direct materials purchasesarrow_forward
- Bodin Company budgets on an annual basis. The following beginning and ending inventory levels (in units) are plannned for the year 20x1. Five units of raw material are required to produce each unit of finished product. Raw material Work in process Finished goods January 1 December 31 36,000 17,000 98,000 51,000 17,000 62,000 Required: 1. If Bodin Company plans to sell 472,000 units during the year, compute the number of units the firm would have to manufacture during the year. 2. If 509,000 finished units were to be manufactured by Bodin Company during the year, determine the amount of raw material to be purchased. 1. Required production in units 2. Raw material purchases in units cBook Pro 6) U G K C V. Narrow_forwardQuetzaltenango Candle Inc. projected sales of 41,000 candles for March. The estimated March 1 inventory is 2,100 units, and the desired March 31 inventory is 5,000 units. Prepare a production budget report in units for Quetzaltenango Candle Inc. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Quetzaltenango Candle Inc. Production Budget For the Month Ending March 31 Line Item Description Units Sales 41,000 Estimated beginning inventory, March 1 2,100 X Total units available 43,100 X Expected units to be sold x -5,000 X Total units to be produced in March 38,100 Xarrow_forwardOperating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,600 March 13,600 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: Finished goods inventory on January 1 is 900 units. The desired ending inventory for each month is 20 percent of the next month’s sales. The data on materials used are as follows: Direct Material Per-Unit Usage Unit Cost Part #K298 2 $4 Part #C30 3 7 Inventory policy dictates that sufficient materials be on hand at the beginning of the month to satisfy 30 percent of the next month’s production needs. This is exactly the amount of material on hand on…arrow_forward
- The budget director of Royal Furniture Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for February is summarized as follows: a. Estimated sales of King and Prince chairs for February by sales territory: Northern Domestic: King 610 units at $780 per unit Prince 750 units at $550 per unit Southern Domestic: King 340 units at $780 per unit Prince 440 units at $550 per unit International: King 360 units at $850 per unit Prince 290 units at $600 per unit b. Estimated inventories at February 1: Direct materials: Fabric 420 sq. yds. Wood 580 linear ft. Filler 250 cu. ft. Springs 660 units Finished products: King 90 units Prince 25 units c. Desired inventories at February 28: Direct materials: Fabric 390 sq. yds. Wood 650 linear ft. Filler 300 cu. ft.…arrow_forwardThe following information is located in the production department of Mindy Ca Second First Quarter 14,300 Quarter Third Quarter Fourth Quarter 21,000 22,500 21,300 Units produced Other information found in the production department includes: Prior Year Ending RM Inventory Prior Year Ending A/P Pounds of RM per unit The ending raw material inventory per month should be 25% of the following month's production needs. The desired ending inventory for the fourth quarter is 3,700 pounds. Management plans to pay for 70% of the raw material purchases in the month bought and 30% in the following month. Direct Materials Budget Question: Given the data, the second quarter direct materials budget should be: Costs of Raw Materials per pound 5. $ Cost of DM Purchased: 10,725 11,775 First Second Quarter Quarter Third Quarter Fourth Quarter $ 4.50 $ 4.50 $ 4.50 $ 4.50arrow_forwardplease answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education