Expects to have a cash balance of $41,400 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $78,200, February $138,000. Payments for direct materials: January $46,000, February $69,000. Direct labor: January $27,600, February $41,400, Wages are paid in the month they are incurred. Manufacturing overhead: January $19,320, February $23,000. These costs include depreciation of $1,380 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $13,800, February $18,400, These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $11.040 in cash. Coronado Company has a line of credit at a local bank that enables it to borrow up to $23,000. The company wants to maintain a minimum monthly cash balance of $18,400. Prepare a cash budget for January and February.

In Ayayai Company, direct labor is $20 per hour. The company expects to operate at 12,400 direct labor hours each month. In January 2027, direct labor totaling $255,440 is incurred in working 12,896 hours. (a) Your answer is correct. Prepare a static budget report. Product Line Direct Labor CA $ Budget 248,000 +A $ AYAYAI COMPANY Static Direct Labor Budget Report For the Month Ended January 31, 2027 Actual 255,440 +A Difference 7,440 i Unfavorable

Kronos Ltd is preparing a cash budget for May and June of 2021.   Past records reveal that 15% of all credit sales are collected during the month of sale, 45% in the month following the sale, 30% in the second month following the sale and 10% in the third month following the sale.   The company pays for 55% of purchases in the month after purchase, and the balance is paid in the month following that.   Selling expenses amount to $2 400 per month plus 10% of monthly sales.   Administrative expenses are estimated to be $9 800 per month, which includes $2 600 of depreciation expense.   Finance expenses are $1600 per month.   All selling and distribution, administrative, and finance and other expenses (except depreciation) are paid for when incurred.   It is planned to purchase equipment during May 2019 at a cost of $7 500.   A $5 800 loan payable will be repaid in full including interest charges during June 2019. The interest due at maturity date will be $750.     The company’s expected…

Create a cash budget from April to July based on the following information.   Unit sales for April = $9,000, May = 10,200, June =11,544, July = 12,049 Selling price per unit is $3.05. Sales are 50% credit and 50% cash. Sales terms are net 30 days Cost of Goods per unit is $1.95. Terms of Purchase are net 30 days Opening Accounts Payable balance in Apr is $5,000 and the Opening Cash balance is 10,000 A minimum cash balance of $3,000 is required at all times Expenses are 45% of Sales and are paid in the month they are incurred The company will be purchasing new equipment for $12,000 and must pay for in Apr Show the work on excel and step by step.

Zira Company reports the following production budget for the next four months. Each finished unit requires six pounds of direct materials, and the company wants to end each month with direct materials inventory equal to 40% of next month's production needs. Beginning direct materials inventory for April was 1,541 pounds. Direct materials cost $5 per pound. Prepare a direct materials budget for April, May, and June. (Round your answers to the nearest whole number.) April May June 642 670 676 Units to produce Check my work July 656

Echo Amplifiers prepared the following sales budget for the first quarter of 2018:   Jan. Feb. Mar. Units 800 1,300 1,500 Sales price $100 $100 $100 Budgeted sales $80,000 $130,000 $150,000 It also has this additional information related to its expenses: Direct material per unit $1.50 Direct labor per unit 2 Variable manufacturing overhead per hour 0.50 Fixed manufacturing overhead per month 2,900 Sales commissions per unit 15 Sales salaries per month 5,100 Delivery expense per unit 0.40 Factory utilities per month 5,000 Administrative salaries per month 21,000 Marketing expenses per month 8,000 Insurance expense per month 11,000 Depreciation expense per month 10,000   Prepare a sales and administrative expense budget for each month in the quarter ending March 31, 2018. Enter all amounts as positive numbers. Echo AmplifiersSales and Administrative BudgetFor the Quarter Ending March 31, 2018   January February March Budgeted Sales in Units…

Phoenix Company reports the following fixed budget. It is based on an expected production and sales volume of 15,400 units. Sales Costa PHOENIX COMPANY Fixed Budget For Year Ended December 31 Direct materials Direct labor Sales staff commissions Depreciation-Machinery Supervisory salaries Shipping Sales staff salaries (fixed annual amount) Administrative salaries Depreciation-office equipment Income $ 3,234,000 1,001,000 246,400 46,200 295,000 198,000 231,000 251,000 610,700 193,000 $ 161,700

Echo Amplifiers prepared the following sales budget for the first quarter of 2018: Jan. Feb. Mar. Units BOD Sales price $100 $100 Budgeted sales $80,000 $130,000 $100,000 It also has this additional information related to its expenses: Direct material per unit Direct labor per unit Variable manufacturing overhead per hour Fixed manufacturing overhead per month Sales commissions per unit Sales salaries per month Delivery expense per unit Factory utilities per month Administrative salaries per month Marketing expenses per month Insurance expense per month Depreciation expense per month Budgeted Sales in Units Variable Expenses Sales Commissions 1,300 Delivery Total Variable Expenses Fixed Expenses Sales Salaris $100 Administrative Salaries Marketing Expenses Insurance Expense Depreciation Expense 1,500 Total Fixed Expenses Total Selling and Administrative Expenses $1.50 2 Prepare a sales and administrative expense budget for each month in the quarter ending March 31, 2018. Enter all…

The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming fiscal year: 1st Quarter 11, 200 2nd Quarter 8,500 3rd Quarter 8,600 4th Quarter 10,980 Units to be produced Each unit requires 0.55 direct labor-hours, and direct laborers are paid $16.00 per hour. Required: 1. Prepare the company's direct labor budget for the upcoming fiscal year. (Round "Direct labor time per unit (hours)" answers to 2 decimal places.) Direct labor time per unit (hours) Total direct labor-hours needed Direct labor cost per hour Total direct labor cost Rordan Corporation Direct Labor Budget 2nd Quarter 1st Quarter 3rd Quarter 4th Quarter Year

(b) A sales budget is given below for one of the products manufactured by N.Ltd .For six months ended 30th June 2021. Month Units January 60,000 February 105,000 March 180,000 April 120,000 May 90,000 June 75,000 The inventory of finished goods at the end of each month equal 20% at the next month's sales Page 1 of 4 On 1t Jan 2021, finished goods inventory totaled 12,000 units. Each unit of the product requires nine units of a specialized liquid known as HN-2, sometimes this extract is in short supply for this reason, the company has a policy of maintaining an inventory at the end of each month equal to 30%of next month's production needed. This requirement was met on 1st Jan 2021. Required Prepare a budget showing the quantity of NH-2 to be purchased each month from January, February and March and in total for the three months period (ii) What is the significance of budgeting in any business organization