ats of the same question are to be answered consecutively.. If anv similarity is found with your friends, both of you will get zero. Don't share your answscripV. Aprepared and submitted in Excel Sheet. Use formula where needed.1. XYZ Company distributes a single product. The company's sales and expenses for last month10follow:TotalPer UnitSalesTk 5,00,000Tk 50Variable expensesContribution marginFixed expensesNet operating income2,00,000203,00,000Tk 302,30,000Tk 70,000Requirements:A) What is the monthly break-even point in unit sales and in Taka sales?B) Without resorting to computations, what is the total contribution margin at the break-even point?C) How many units would have to be sold each month to earn a target profit of Tk 1,00,000? Verifyyour answer by preparing a contribution format income statement at the target sales level.D) Refer to the original data. Compute the margin of safety in both Taka and percentage terms.E) What is the company's CM ratio? If sales increase by Tk 50,000 per month and there is no changein fixed expenses, by how much would you expect monthly net operating income to increase?2. You have been asked to prepare a December cash budget for Ahnaf Company, a distributor of 10exercise equipment. The following information is available about the company’s operations:a. The cash balance on December 1 is Tk 45,000.b. Actual sales for October and November and expected sales for December are as follows:OctoberNovemberDecemberCash sales . ...Tk 60,000Tk 75,000Tk 80,000Tk 450,000Tk 520,000Tk 600,000Sales on accountSales on account are collected over a three-month period as follows: 20% collected in the month ofsale, 60% collected in the month following sale, and 18% collected in the second month followingsale. The remaining 2% is uncollectible.c. Purchases of inventory will total Tk 280,000 for December. Thirty percent of a month's inventorypurchases are paid during the month of purchase. The accounts payable remaining from November'sinventory purchases total Tk 161,000, all of which will be paid in December.d. Selling and administrative expenses are budgeted at Tk 430,000 for December. Of this amount,Tk 50,000 is for depreciation.e. A new web server for the Marketing Department costing Tk 76,000 will be purchased for cashduring December, and dividends totaling Tk 9,000 will be paid during the month.f. The company maintains a minimum cash balance of Tk 20,000. An open line of credit is availablefrom the company's bank to bolster the cash position as needed.Requirements:A) Prepare a schedule of expected cash collections for December.B) Prepare a schedule of expected cash disbursements for merchandise purchases for December.C) Prepare a cash budget for December. Indicate in the financing section any borrowing that will beneeded during the month. Assume that any interest will not be paid until the following month.

Since we only answer up to 3 sub-parts, we’ll answer the first 3 sub-parts of question 1. Please…

1. XYZ Company distributes a single product. The company's sales and expenses for last month follow: 10 Total Per Unit Sales. Variable expenses. Contribution margin Fixed expenses. Net operating income. Tk 5,00,000 Tk 50 .... 2,00,000 3,00,000 2,30,000 Tk 70,000 20 Tk 30 Requirements: A) What is the monthly break-even point in unit sales and in Taka sales? B) Without resorting to computations, what is the total contribution margin at the break-even point? C) How many units would have to be sold each month to earn a target profit of Tk 1,00,000? Verify your answer by preparing a contribution format income statement at the target sales level. D) Refer to the original data. Compute the margin of safety in both Taka and percentage terms. E) What is the company's CM ratio? If sales increase by Tk 50,000 per month and there is no change in fixed expenses, by how much would you expect monthly net operating income to increase?

1. XYZ Company distributes a single product. The company's sales and expenses for last month follow: 10 Total Per Unit Sales. Variable expenses. Contribution margin Fixed expenses. Net operating income. Tk 5,00,000 Tk 50 .... 2,00,000 3,00,000 2,30,000 Tk 70,000 20 Tk 30 Requirements: A) What is the monthly break-even point in unit sales and in Taka sales? B) Without resorting to computations, what is the total contribution margin at the break-even point? C) How many units would have to be sold each month to earn a target profit of Tk 1,00,000? Verify your answer by preparing a contribution format income statement at the target sales level. D) Refer to the original data. Compute the margin of safety in both Taka and percentage terms. E) What is the company's CM ratio? If sales increase by Tk 50,000 per month and there is no change in fixed expenses, by how much would you expect monthly net operating income to increase?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Data concerning Follick Corporation's single product appear below: Selling price per unit $ 200.00 Variable expense per unit $ 72.00 Fixed expense per month $ 135,680 The break-even in monthly dollar sales is closest to: (Round your intermediate calculations to 2 decimal places.)
Break-Even Units and Sales Revenue: Margin of Safety Dupli-Pro Copy Shop provides photocopying service. Next year, Dupli-Pro estimates it will copy 2,890,000 pages at a price of $0.06 each in the coming year. Product costs include: Direct materials Direct labor Variable overhead Total fixed overhead $0.009 $0.003 $0.001 $84,320 There is no variable selling expense; fixed selling and administrative expenses total $36,000.
Raven Inc. sells a single product for $50. Variable costs include $29.00 for each unit plus a $7 selling expense per unit. Fixed costs are $276,920 per month. a. What is the contribution margin percentage? Contribution Margin b. What is the break-even sales revenue? Break-Even Sales Revenue c. What sales revenue is needed to achieve a $250,740 per month profit? Total Sales Revenue Needed
6. Craig Company Inc. earns a contribution margin ratio of 36% on its main product is sold at $120 per unit. Assume that the annual break-even point is 80,000 units. 1. Compute the annual total fixed costs. 2. What is the contribution margin for every unit sold beyond the break-even point? (Round your answer to 2 decimal places).
Halifax Products sells a product for $118. Variable costs per unit are $67, and monthly fixed costs are $168,300. a. What is the break-even point in units? Break-Even Point units b. How many units would need to be sold to earn a target profit of $102,000? Total Required Sales units c. Assuming they achieve the level of sales required in part b, what is the margin of safety in sales dollars? Margin of Safety
Assume the following data for Dodge Company for the coming year: Fixed expenses $280,000 Variable cost per unit Selling price per unit $7 $21 Do not enter dollar signs or commas in the input boxes. Round all answers to the nearest whole number. For Unit calculations round your answers up to the nearest whole number. a) How many units must be sold to break even? Break even sales: units b) What would the net income be if 26,200 units were sold? Net income: $ c) How many units must be sold to make a net income of $33,000 assuming selling price per unit is increased by $1.00 Total units to be sold: units
Mauro Products sells a woven basket for $14 per unit. Its variable expense is $11 per unit and the company's monthly fixed expense is $9,000. Required: 1 Calculate the company's break-even point in unit sales 2 Calculate the company's break-even point in dollar sales Note: Do not round intermediate calculations. 3. If the company's fixed expenses increase by $600, what would become the new break even point in unit sales? In dollar sales? Note: Do not round intermediate calculations. 1. Break-even point in unit sales 2 Break-even point in dollar sales 3. Break-even point in unit sales 3. Break-even point in dollar sales baskets baskets
Great Inc.'s contribution margin ratio is 48% and its fixed monthly expenses are $36,000. Assuming that the fixed monthly expenses do not change, what is the best estimate of the company's net operating income in a month when sales are $140,000? A. $13,440 B. $23,740 C. $67,000 D. $31,200
Gayne Corporation's contribution margin ratio is 19% and its fixed monthly expenses are $50,500. If the company's sales for a month are $312,000, what is the best estimate of the company's net operating income? Assume that the fixed monthly expenses do not change. Multiple Choice $202,220 $8,780 $261,500 $59,280
Do not give image format
Menlo Company distributes a single product. The company's sales and expenses for last month follow: Total Per Unit Sales $ 608, 000 $ 40 Variable expenses 425, 600 28 Contribution margin 182, 400 $ 12 Fixed expenses 154,800 Net operating income $ 27,600 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the total contribution margin at the break-even point? 3- a. How many units would have to be sold each month to attain a target profit of $ 50, 400? 3-b. Verify your answer by preparing a contribution format income statement at the target sales level. 4. Refer to the original data. Compute the company's margin of safety in both dollar and percentage terms. 5. What is the company's CM ratio? If the company can sell more units thereby increasing sales by S 50,000 per month and there is no change in fixed expenses, by how much would you expect monthly net operating income to increase?