Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/665841d6cc20d_054665841d6c51d9.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/665841d73065a_055665841d726552.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/665841d778473_055665841d77141e.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/665841d7b0987_055665841d7aa8e7.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/665841d7e54e0_055665841d7e13d9.jpg)
Transcribed Image Text:
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 February March April May 10,000 10,600 13,300 16,000 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: a. 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. b. The data on materials used are as follows: Direct Material Per-Unit Usage Unit Cost Part #K298 Part #C30 2 3 $4 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. c. The direct labor used per unit of output is one and one-half hours. The average direct labor cost per hour is $20. d. Overhead each month is estimated using a flexible budget formula. (Activity is measured in direct labor hours.) Variable Cost Component Fixed Cost Component Supplies Power $- $1.00 0.20 Maintenance 12,600 1.10 Supervision 14,000 Depreciation 45,000 Taxes Other 4,300 86,000 1.60 e. 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,600 Commissions $1.40 Depreciation Shipping Other 25,000 137,000 3.60 1.60 f. The unit selling price of the wiring harness assembly is $110. g. In February, the company plans to purchase land for future expansion. The land costs $68,000. h. 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: 1. Sales budget Units January February March Total 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 February March April May 10,000 10,600 13,300 16,000 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: a. 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. b. The data on materials used are as follows: Direct Material Per-Unit Usage Unit Cost Part #K298 Part #C30 2 3 $4 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. c. The direct labor used per unit of output is one and one-half hours. The average direct labor cost per hour is $20. d. Overhead each month is estimated using a flexible budget formula. (Activity is measured in direct labor hours.) Variable Cost Component Fixed Cost Component Supplies Power $- $1.00 0.20 Maintenance 12,600 1.10 Supervision 14,000 Depreciation 45,000 Taxes Other 4,300 86,000 1.60 e. 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,600 Commissions $1.40 Depreciation Shipping Other 25,000 137,000 3.60 1.60 f. The unit selling price of the wiring harness assembly is $110. g. In February, the company plans to purchase land for future expansion. The land costs $68,000. h. 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: 1. Sales budget Units January February March Total
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
An initially empty spring-loaded piston/cylinder requires 100 kPa to float the piston. A compressor with a line and valve now charges the cylinder with water to a final pressure of 1.4 MPa at which...
-
What is communication?
-
The figure shows a steel countershaft that supports two pulleys. Pulley C receives power from a motor producing the belt tensions shown. Pulley A transmits this power to another machine through the...
-
String Adjusted Trial Balance December 31, 2019 Cash 219,600 Accounts Receivable 98,500 Allowance for Doubtful Accounts 6,500 Inventory 134,900 Prepaid Insurance 11,000 Equipment 178,400 Accumulated...
-
The attached Excel sheet contains two years of quarterly sales data for a company. Based on the data, develop the forecasting models for quarters 1-4 for 2010. Sales forecast for 2010 using moving...
-
A company paid $217.50 for an item. The original price was $296.60, but this was marked down 40%. If the operating expenses are 35% of the cost, find the operating loss and the absolute loss What is...
-
Grandiose Growth has a dividend growth rate of 20%. The discount rate is 15%. The end-of-year dividend will be $6 per share. a. What is the present value of the dividend to be paid in: Year 1? Year...
-
For the year ended December 31, 2024, Norstar Industries reported net income of $900,000. At January 1, 2024, the company had 700,000 common shares outstanding. The following changes in the number of...
-
Clayton Ltd. is debt-free with assets projected to be $900 million in a strong economy and $300 million in a weak economy next year, each with equal likelihood. Presently, the market values its...
-
Sole Sisters Company has two product lines: Hiking boots and Fashion boots. Income statement data for the most recent year follow Sales revenue Variable expenses Contribution margin Fixed expenses...
-
6. Arrivals to the express line of a grocery store follow a Poisson distribution with a mean rate of 20 per hour. Suppose that each transaction follows an exponential distribution with a mean of 2...
-
Assume that you are buying a share of preferred stock that pays an annual dividend of $7 per share for $87. What will R p be? a. 7.00% b. 8.05% c. 9.10% d. 9.85%
-
Your company is considering selling a newly developed portable video product, the j View. You have developed some forecasts for unit sales and selling price per unit, shown below. You also anticipate...
-
The payoff diagram in Figure 17-13 represents what combination of positions? a. Long put at $45 and long put at $50 b. Long put at $45 and short call at $50 c. Short put at $45 and long put at $50 d....
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App