Please answer all the following questions down below.
Royal Lawncare Company produces and sells two packaged productsWeedban and Greengrow. Revenue and cost information relating to the products follow: Product Weedban Greengrow Selling price per unit 5 10.00 $ 36.00 Variable expenses per unit $ 2.90 $ 13.00 Traceable fixed expenses per year $ 136,000 $ 33,000 7__________________________________________________________ Last year the company produced and sold 39,500 units of Weedban and 15,500 units of Greengrow. Its annual common fixed expenses are $98,000. Required: Prepare a contribution format income statement segmented by product lines. Four grams of musk oil are required for each bottle of Mink Caress, a very popular perfume made by a small company in western Siberia. The cost of the musk oil is $2.20 per gram. Budgeted production of Mink Caress is given below by quarters for Year 2 and for the first quarter of Year 3: Year 2 Year 3 First Second Third Fourth First Budgeted production, in bottles 100 , 000 130 , 000 190,000 140, 000 110 , 000 The inventory of musk oil at the end of a quarter must be equal to 20% of the following quarter's production needs. Some 80,000 grams of musk oil will be on hand to start the first quarter of Year 2. Required: Prepare a direct materials budget for musk oil, by quarter and in total, for Year 2. Mink Caress Direct Materials Budget - Year 2 Quarter First Second Third Fourth Year Units of raw materials needed per unit of finished goods Units of raw materials needed to meet production Total units of raw materials needed Units of raw materials to be purchased Unit cost of raw materials Cost of raw materials to purchasedThe production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming fiscal year: lst Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 9,600 7,500 7,800 10,100 ' Each unit requires 065 direct labor-hours, and direct laborers are paid $10.00 per hour. Required: 1. Prepare the company's direct labor budget for the upcoming scal 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 The direct labor budget of Yuvwell Corporation for the upcoming fiscal year contains the following details concerning budgeted direct labor-hours: Ist Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted direct labor-hours 11 , 400 9 , 900 10 , 200 11 , 000 The company uses direct labor-hours as its overhead allocation base. The variable portion of its predetermined manufacturing overhead rate is $6.25 per direct labor-hour and its total fixed manufacturing overhead is $82,000 per quarter. The only noncash item included in fixed manufacturing overhead is depreciation, which is $20,500 per quarter. Required: 1. Prepare the company's manufacturing overhead budget for the upcoming fiscal year. 2. Compute the company's predetermined overhead rate (including both variable and fixed manufacturing overhead) for the upcoming fiscal year. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare the company's manufacturing overhead budget for the upcoming fiscal year. (Round "Variable manufacturing overhead rate" answers to 2 decimal places.) Yuvwell Corporation Manufacturing Overhead Budget Variable manufacturing overhead rate Variable manufacturing overhead Fixed manufacturing overhead Total manufacturing overhead Cash disbursements for manufacturing overheadThe direct labor budget of Yuvwell Corporation for the upcoming fiscal year contains the following details concerning budgeted direct labor-hours: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted direct labor-hours 11 , 400 9 , 900 10 , 200 11 , 000 The company uses direct labor-hours as its overhead allocation base. The variable portion of its predetermined manufacturing overhead rate is $6.25 per direct labor-hour and its total fixed manufacturing overhead is $82,000 per quarter. The only noncash item included in fixed manufacturing overhead is depreciation, which is $20,500 per quarter. Required: 1. Prepare the company's manufacturing overhead budget for the upcoming fiscal year. 2. Compute the company's predetermined overhead rate (including both variable and fixed manufacturing overhead) for the upcoming fiscal year. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute the company's predetermined overhead rate (including both variable and fixed manufacturing overhead) for the upcoming fiscal year. (Round your answer to 2 decimal places.) Predetermined overhead rate for the yearWeller Company's budgeted unit sales for the upcoming scal year are provided below: lst Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 23,000 24,000 21,000 21,000 The company's variable selling and administrative expense per unit is $2.20. Fixed selling and administrative expenses include advertising expenses of $8,000 per quarter, executive salaries of $41,000 per quarter, and depreciation of $22,000 per quarter. In addition. the company will make insurance payments of $5,000 in the first quarter and $5,000 in the third quarter. Finally. property taxes of $7,400 will be paid in the second quarter. Required: Prepare the company's selling and administrative expense budget for the upcoming scal year. (Round "Per Unit" answers to 2 decimal places.) Variable selling and administrative expense per unit Variable selling and administrative expense Fixed selling and administrative expenses: _ ___ Cash disbursements for selling and administrative expenses Garden Depot is a retailer that is preparing its budget for the upcoming scal year. Management has prepared the following summary of its budgeted cash flows: lst Quarter 2nd Quarter 3rd Quarter 4th Quarter Total cash receipts $ 290,000 $ 440,000 $ 320,000 $ 340,000 Total cash disbursements S 337,000 3 307,000 $ 297,000 3 317,000 ' The company's beginning cash balance for the upcoming fiscal year will be $42,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning ofany quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Required: Prepare the company's cash budget for the upcoming fiscal year. (Repayments, and interest, should be indicated by a minus sign.) Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deciency) of cash available over disbursements Financing: Borrowings Re payments Interest Total nancing Ending cash balance Gig Harbor Boating is the wholesale distributor of a small recreational catamaran sailboat. Management has prepared the following summary data to use in its annual budgeting process: Budgeted unit sales 660 Selling price per unit 3 2,050 Cost per unit $ 1,480 variable selling and administrative expense (per unit) 5 85 Fixed selling and administrative expense (per year) S 245,000 Interest expense for the year $ 21,000 I Required: Prepare the company's budgeted income statement for the year. The management of Mecca Copy. a photocopying center located on University Avenue, has compiled the following data to use in preparing its budgeted balance sheet for next year: Ending Balances Cash ? Accounts receivable $ 9,700 Supplies inventory $ 3,800 Equipment $ 42,000 Accumulated depreciation $ 17,000 Accounts payable $ 3,400 Common stock $ 5,000 Retained earnings '2 [ The beginning balance of retained earnings was $33,000, net income is budgeted to be $16,900, and dividends are budgeted to be $3,500. Required: Prepare the company's budgeted balance sheet. (Amounts to be deducted should be indicated by a minus sign.) Assets Current assets: Total cu rrent assets Plant and equipment: Plant and equipment, net Total assets Liabilities and Stockholders' Equity Current liabilities: Stockholders' equity: Total stockholders' equity Total liabilities and stockholders' equity A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $10,000 to start each quarter. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) Quarter (000 omitted) (000 omitted) 1 2 3 4 Year Cash balance, beginning $ 7 Add collections from customers 113 391 Total cash available 72 Less disbursements: Purchase of inventory 52 62 28 Selling and administrative expenses 45 30 106 Equipment purchases 15 9 27 61 Dividends 2 2 2 2 Total disbursements 118 Excess (deficiency) of cash available over disbursements (7) 11 Financing: Borrowings 14 Repayments (including interest) * (31) Total financing Cash balance, ending *Interest will total $1,000 for the year.Piedmont Company segments its business into two regionsNorth and South. The company prepared the contribution format segmented income statement as shown: Total Company North South Sales $ 825,000 $ 550,000 $ 275,000 Variable expenses 495,000 385,000 110,000 Contribution margin 330,000 165,000 165,000 Traceable fixed expenses 144,000 72,000 72,000 Segment margin 186,000 $ 93,000 $ 93,000 Common fixed expenses 64,000 Net operating income $122:000 [ Required: 1. Compute the companywide break-even point in dollar sales. 2. Compute the break-even point in dollar sales for the North region. 3. Compute the break-even point in dollar sales for the South region. (For all requirements, round your intermediate calculations to 2 decimal places. Round your nal answers to the nearest dollar.) a Dollar sales for company to break-even _ a Dollar sales for North segment to break-even _ 3. Dollar sales for South segment to break-even Shannon Company segments its income statement into its North and South Divisions. The company's overall sales, contribution margin ratio, and net operating income are $600,000, 30%, and $12,000, respectively. The North Division's contribution margin and contribution margin ratio are $68,000 and 34%, respectively. The South Division's segment margin is $40,000. The company has $60,000 of common fixed expenses that cannot be traced to either division. Required: Prepare an income statement for Shannon Company that uses the contribution format and is segmented by divisions. In addition, for the company as a whole and for each segment, show each item on the segmented income statements as a percent of sales. (Round your percentage answers to 1 decimal place (i.e .1234 should be entered as 12.3).) Ida Company produces a handcrafted musical instrument called a gamelan that is similar to a xylophone. The gamelans are sold for $902. Selected data for the company's operations last year follow: Units in beginning inventory 0 Units produced 12,000 Units sold 8,000 Units in ending inventory 4,000 Variable costs per unit: Direct materials $ 250 Direct labor $ 380 Variable manufacturing overhead 5 64 Variable selling and administrative $ 24 Fixed costs: Fixed manufacturing overhead $940 , 000 Fixed selling and administrative $630,000 [ Required: 1. Assume that the company uses absorption costing. Compute the unit product cost for one gamelan. (Round your intermediate calculations and final answer to the nearest whole dollar amount.) 2. Assume that the company uses variable costing. Compute the unit product cost for one gamelan. Absorption costing unit product cost - Variable costing unit product cost - Ida Company produces a handcrafted musical instrument called a gamelan that is similar to a xylophone. The gamelans are sold for $920. Selected data for the company's operations last year follow: Units in beginning inventory 0 Units produced 275 Units sold 260 Units in ending inventory 15 Variable costs per unit: Direct materials $ 1 1 0 Direct labor $ 320 Variable manufacturing overhead 5 40 Variable selling and administrative $ 15 Fixed costs: Fixed manufacturing overhead $ 77,000 Fixed selling and administrative $ 33,000 The absorption costing income statement prepared by the company's accountant for last year appears below: Sales $ 239,200 Cost of goods sold 195,000 Gross margin 44,200 Selling and administrative expense 36,900 Net operating income $ 7,300 [ Required: 1. Under absorption costing. how much xed manufacturing overhead cost is included in the company's inventory at the end of last year? 2. Prepare an income statement for last year using variable costing. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Under absorption costing, how much xed manufacturing overhead cost is included in the company's inventory at the end of last year? Ida Company produces a handcrafted musical instrument called a gamelan that is similar to a xylophone. The gamelans are sold for $920. Selected data for the company's operations last year follow: Units in beginning inventory 0 Units produced 275 Units sold 260 Units in ending inventory 15 Variable costs per unit: Direct materials $ 110 Direct labor $ 320 Variable manufacturing overhead $ 40 Variable selling and administrative $ 15 Fixed costs: Fixed manufacturing overhead $ 77,000 Fixed selling and administrative $ 33,000 I The absorption costing income statement prepared by the company's accountant for last year appears below: Sales $ 239,200 Cost of goods sold 195,000 Gross margin 44,200 Selling and administrative expense 36,900 Net operating income $ 7:300 [ Required: 1. Under absorption costing, how much fixed manufacturing overhead cost is included in the company's inventory at the end of last year? 2. Prepare an income statement for last year using variable costing. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare an income statement for last year using variable costing. Required information [T he following information applies to the questions displayed below] Jorgansen Lighting, Inc., manufactures heavy-duty street lighting systems for municipalities. The company uses variable costing for internal management reports and absorption costing for external reports to shareholders, creditors, and the government. The company has provided the following data: Year 1 Year 2 Year 3 Inventories Beginning (units) 220 160 190 Ending (units) 160 190 230 Variable costing net operating income $300,000 $269,000 $260,000 The company's fixed manufacturing overhead per unit was constant at $570 for all three years. Required: 1. Calculate each year's absorption costing net operating income. (Enter any losses or deductions as a negative value.) Variable oosting net operating income Add (deduct) xed manufacturing overhead deferred in (released from) inventory under absorption costing Absorption costing net operating income Required information [The following information applies to the questions displayed below. ] Jorgansen Lighting, Inc., manufactures heavyduty street lighting systems for municipalities The company uses variable costing for internal management reports and absorption costing for external reports to shareholders. creditors, and the government. The company has provided the following data: Year 1 Year 2 Year 3 Inventories Beginning (units) 220 160 190 Ending (units) 160 190 230 Variable costing net operating income $300,000 $269,000 $260,000 [ The company's fixed manufacturing overhead per unit was constant at $570 for all three years. 2' Assume in Year 4 that the company's variable costing net operating income was $240,000 and its absorption costing net operating income was $290,000. a. Did inventories increase or decrease during Year 4? 0 Increase O Decrease b. How much xed manufacturing overhead cost was deferred or released from inventory during Year 4? Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $500,000 $700,000 $240,000 $1,440,000 From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale. and the remaining 20% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $430,000, and March sales totaled $460,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. February sales March sales April sales May sales June sales Total cash collections $ 0 $ 0 $ Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: Apri 1 May June Total Budgeted sales (all on account) $500,000 $700,000 $240,000 $1,440,000 From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the remaining 20% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $430,000, and March sales totaled $460,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? Complete this question by entering your answers in the tabs below. Required 1 Required 2 What is the accounts receivable balance on June 30th? Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows: Unit Sales April 86,000 May 90,000 June 126,000 July 98,000 The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of- month inventory levels must equal 10% of the following month's unit sales. The inventory at the end of March was 8,600 units. Required: Prepare a production budget by month and in total. for the second quarter