Please Show all work and finish all sections especially report at the end Manny
ID: 2572041 • Letter: P
Question
Please Show all work and finish all sections especially report at the end
Manny Fold owns a factory that specializes in making titanium valves for high performance engines on a just in time basis. Thus, Manny produces what he sells in a particular month. There are no inventories of finished goods or work in process. However, Manny does require that an inventory of direct raw materials equal to 20% of next month’s production requirement be available at the end of each month. To build his business and gain new customers Manny has extended generous credit terms to his customers. While Manny is confident about the fundamentals of his business, he is concerned about the possible income and cash flow implications.
The variable costs of producing a valve are budgeted at $7.20 per valve for direct materials (3/4 pound of titanium alloy costing $9.60 per pound), $2.80 per valve for direct labor, and $5.50 per valve for variable manufacturing overhead. Fixed manufacturing overhead is budgeted at $74,700 per month during the 2nd quarter. The detailed components of variable and fixed overhead are as listed below.
For variable overhead, electric power is budgeted at $2.30 per unit, indirect labor is budgeted at $2.50 per unit, and supplies are budgeted at $.70 per unit. For fixed overhead depreciation is budgeted at
$10,000 per month, Supervision and other factory salaries are budgeted at $40,000 per month, property tax and insurance combined are budgeted at $8,000 per month (which have been paid in advance through June 15 – see below), maintenance is budgeted at $7,000 per month, licensing fees and permits to use proprietary technology are budgeted at $3,400 per month, and other miscellaneous fixed overhead expenses are budgeted at $6,300 per month.
Manny’s customers drive a hard bargain because they can easily switch suppliers. They all do pay eventually, but many of them take their time about doing so and Manny is reluctant to get tough with them for fear they will take their business elsewhere. He tells you that all his sales are on credit (no cash sales). He typically collects only 10% of sales in the month of the sale, 30% of sales in the month after the sale and 60% of sales two months later (for example 10% of June sales would be collected in June, 30% in July and 60% in August). On the other hand, he must pay for 70% of his materials purchases in the same month of the purchase and 30% in the month after. Cash costs of labor and overhead other than depreciation, property taxes and insurance are paid in the same month they are incurred. Property taxes and insurance are paid in advance through June 15. The amount due for the next 6 months (starting June 16) must be paid in early June.
All of the selling and administrative expenses are fixed. Monthly fixed selling and administrative costs, other than interest, amount to $43,600, of which $6,000 is depreciation. These operating costs, excepting depreciation, are paid in cash in the month incurred. Manny has large tax loss carry forwards from a previous unsuccessful business venture. Therefore, he does not expect to pay any income taxes this year. (In other words you may ignore income taxes).
Manny plans to buy new equipment costing $80,000 during the month of June. This equipment will be ready for use starting in July.
The budgeted selling price of valves for April, May, and June is $23 per valve. Because of market competition there is not much flexibility to adjust the price and the price is expected to be stable during the 2nd quarter. Manny budgeted sales in units for April at 17,000 units. For May he expects to sell only 18,500 units. He has projected sales of 20,000 units for June and 18,000 units for July.
Manny requires a minimum cash balance of $10,000 at the end of each month. If the budgeted month end cash balance will fall below this level Manny plans to borrow enough cash at the beginning of that same month to keep his ending balance up to the minimum level. Manny’s bank charges him interest at the rate of ½ % per month on the balance outstanding during that month. Manny’s bank charges him interest at the rate of ½ % per month on the balance outstanding during that month. Manny pays the interest at the beginning of the following month and plans to repay as much as he can at the beginning of that month without letting his budgeted cash balance go below $10,000 at month end. (On the budgeted income statement round interest expense to the nearest dollar)
The company’s managerial accountant has resigned unexpectedly before the 2nd quarter budget could be completed. You have been contracted to complete the master budget for June and for the 2nd quarter (including some missing numbers from May). Balances as of March 31 for all relevant accounts have already been calculated by this accountant together with some of the amounts for April and May. You may assume that these balances and amounts shown in the tables below are correct.
1) Construct Manny's budgeted income statement for June and the total for the 2nd quarter. April and May have already been provided. Complete the template provided below. Show your calculations where indicated on the extra page provided. (7 points) Using the same forecast as in requirement 1 construct Manny's budget for raw materials purchases in June and the total for the 2nd quarter (You will also have to complete the budget for May) Complete the template provided which already has information for April and May. (2 points) Using the same forecast as you used in requirement 1 construct Manny's cash budgets for June and the total for the 2nd quarter (You will also have to provide the missin,g number for May payments for purchases). Complete the templates provided below which already have information for April and May. Show your calculations where indicated on the extra page provided. (3 points) Using the same forecast as you used in requirement 1 construct Manny's budgeted balance sheet at the end of June. Complete the template provided which already has the March 31 balances. (3 points) 2) 3) 4) 5) During March Manny actually produced and sold 16,500 valves. Actual sales revenues were S381,950. Actual costs and the original March budget based on 16,000 valve:s were as detailed in the table below. Complete the table by constructing a flexible budget based on 16,500 valves and determining the variances for the performance report. Use the template provided below for your answer. (7 points) Write a brief report explaining some possible reasons why Manny's profits were different from the amount projected in the master budget for March (2 points). 6)Explanation / Answer
1 April May June 2nd Quarter Sales revenue 391,000 425,500 460000 1,276,500 Direct Material used -122,400 -133,200 -144000 -399,600 Direct Labor -47,600 -51,800 -56000 -155,400 Variable Overhead -93,500 -101,750 -110000 -305,250 Contribution Margin 127,500 138,750 150,000 416,250 Fixed Overhead -74,700 -74,700 -74,700 -224,100 Fixed Operating Expense -43,600 -43,600 -43,600 -130,800 Operating Income 9,200 20,450 31,700 61,350 Interest Expense - 0 560 560.00 Net income 9,200 20,450 31,140 60,790.00 JUNE Show Calculations for all items not marked NA SALES REVENUES 20000 units @ 23 DIRECT MATERIALS USED 20000 units @ 7.2 DIRECT LABOR 20000 units @ 2.8 VARIABLE OVERHEAD 20000 units @ 5.5 CONTRIBUTION MARGIN NA FIXED OVERHEAD Its Fixed at 74,700 FIXED OPERATING EXPENSES Its fixed at 43600 OPERATING INCOME NA INTEREST EXPENSE Loan of 111830 @ half percent' NET INCOME NA April May June 2nd quarter 2 Valves to be produced 17,000 18,500 20000 55,500 X Pounds per unit 0.75 0.75 0.75 0.75 Titanium to be used 12,750 13,875 15,000 41,625 Desired ending inventory (20%) 2,775 3,000 2,700 2700 Pounds of Titanium Needed 15,525 16,875 17,700 44,325 Less: Beginning Inventory 2,550 2,775 3,000 2550 Pounds to be purchased 12,975 14,100 14,700 41,775 Cost per pound 9.6 9.6 9.6 9.6 Cost of Purchases 124560 135360 141120 401040 3 April May June 2nd quarter Sales Made 2 Months Ago 213,900 220,800 234,600.00 669,300 Sales Made 1 Month Ago 110,400 117,300 127,650.00 355,350 Sales Made this Month 39,100 42,550 46,000.00 127,650 Total Cash Collections 363,400 380,650 408,250.00 1,152,300.00 Show Calculation for June Total Cash Collections April month sales 60% + May month sales 30% and June month sales 10% April May June 2nd quarter Payments for purchases of materials $122,184 (used to calculate March purchases) 129960 140760 392904 Payments for direct Labor 47,600 51,800 56000 155,400 Payments for Variable Overhead 93,500 101750 110000 305,250 Payments for Fixed Overhead 56,700 56700 56700 170,100 Payments for Property Taxes and Insurance 0 0 48000 48,000 Payments for other operating expenses 37,600 37,600 37600 112,800 Capital Expenditures 0 0 80000 80,000 Total Cash Payments 357,584 377810 529060 1,264,454 April May June 2nd quarter Beginning Balance of Cash 10,324 16,140 18980 10,324 Cash Collections 363,400 380,650 408,250.00 1,152,300 Total cash available 373,724 396,790 427,230 1,162,624 Less: Cash Payments 357,584 377810 529060 1,264,454 Ending Cash Balance Before Financing: 16,140 18,980 -101,830 -101,830 Borrowings 0 0 111830 111830 Repayments 0 0 0 0 Interest Payments 0 0 0 0 End Cash Balance 16,140 18,980 10,000 10,000 Show Calculations for all items not marked NA Payments for purchases of materials for MAY 133200*0.7+122400*0.3 Payments for purchases of materials for JUNE 133200*0.3+144000*0.7 Payments for direct Labor 56000 Payments for Variable Overhead 101750+110000 Payments for Fixed Overhead 56700+56700 Payments for Property Taxes and Insurance 8000 each for 6 months Payments for other operating expenses 37600+37600 Dep wont paid Capital Expenditures 80000 Total Cash Payments NA - ADDITION/SUBTRACTION ONLY May June Beginning Balance of Cash NA- Amounts Already Provided Ending balance of may Cash Collections NA- Amounts Already Provided 408250 Total cash available NA- Amounts Already Provided NA - Addition/Subtraction Only Less: Cash Payments 377810 529060 Ending Cash Balance Before Financing: Total cash - Cash Payment Total cash - Cash Payment Borrowings NIL Deficit+Min Balance+ amount of interest Repayments NIL NIL Interest Payments NIL NIL End Cash Balance NA - Addition/Subtraction Only Calculated Interest would be paid in july 4 Mar-31 Jun-31 ASSETS: Current Assets Cash 10,324 10000 Accounts Receivable 545,100 669300 Inventory (raw materials) 24,480 25920 Prepaid Insurance and Property Taxes 20,000 44000 Total Current Assets 599,904 749,220 Equipment and Furniture 880,000 960,000 Accumulated Depreciation -540,000 -636,000 Equipment & Furniture (net) 340,000 324,000 Total Assets 939,904 1,073,220 LIABILITIES AND EQUITY Liabilities (all current) Accounts Payable 34992 43200 Interest Payable 0 560 Bank Loans Payable 0 111830 Total Liabilities 34992 155590 Owner’s Equity 904,912 917,630 (Net income increases this) Total Liabilities and Equity 939,904.00 1,073,220
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.