Question

In: Accounting

ABC company are doing beraverage business. In their budget of last month, they expected to sell...

ABC company are doing beraverage business. In their budget of last month, they expected to sell 53438 units , with 3046107 units of expected total industry sales. However, the actual sales was 45622 units with 0.0151 market share. The average price was $4.41, and ABC budgeted for $4.09. The actual variable costs were $101235, and ABC budgeted variable costs is $92231.

1. Calculate actual valume

2. Calculate Expected volume

3.Calculate the market share variance

4.Is the above variance favorable or unfavorable?

Solutions

Expert Solution

1.) Actual Industry Volume        3,021,325 (45,622 / 0.0151 )
2.) Expected volume        2,600,574 (3,046,107 / 53,438) x 45,622
3.) Market Share variance:-
= ( Actual Market Share % - Budgeted Market Share % ) x Actual Industry unit x Budgeted Contribution margin per unit
= ( 0.0151 - 0.0175 ) x 3,021,325 x 2.36
= $ 17,113 Unfavorable
Working:
Budgeted market Share             0.0175 (53,438 / 3,046,107 )
Budgeted Contribution per unit 2.36 ( 4.09 - (92,231 / 53,438 ) )

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

ABC Company has the following sales budget for the last six months of 2020:
  Note: Not all sales are always collected. Remember Bad Debt Expense. So don’t worry if the problems do not add up to 100%.   1. ABC Company has the following sales budget for the last six months of 2020:                   July                             $9,000                                          August                      $8,000                                          September                 $11,000                   October                      $9,000                        Historically, the cash collection of sales has been as follows:                                     35% of sales collected in the month of sale,                                     45% of sales collected in the month...
Budget Problem Part A The ABC company manufactures bookcases that sell for $400. Budgeted sales for...
Budget Problem Part A The ABC company manufactures bookcases that sell for $400. Budgeted sales for first months are as follows: Month Budgeted Sales (units) January 1000 February 1500 March 2500 April 2000 Required Calculate sales budget in $ for each monthand total the first quarter Part B Each bookcase requires 30 square feetof oak at a cost of $10 per sq foot.. the company wants to maintain an inventory of bookcases equal to 10% of the following month,s sales....
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash...
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash collections from sales for the first quarter of 2019. They expect sales in January to be $400,000, February to be $300,000, and March to be $500,000. !0% of the sales will be paid for in cash. The remainder will be charged on account. From past experience, the company knows their customers take 3 months to pay their bills in total, with 40% of a...
Company ABC distributes a single product. The company’s sales and expenses for last month follow: Total...
Company ABC distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $450,000 $30 Variable expenses $180,000 $12 Contribution margin $270,000 $18 Fixed expenses $216,000 Net operating income $54,000 What is the monthly break-even point in unit sales and in dollar sales? Without resorting to computations, what is the total contribution margin at the break-even point? How many units would have to be sold each month to earn a target profit of $90,000?...
Last year, ABC Company produced 19,000 units of Product X. The fixed overhead budget was $160,000...
Last year, ABC Company produced 19,000 units of Product X. The fixed overhead budget was $160,000 and the expected level of production for the year was 20,000 units. The actual fixed overhead costs were $162,000. Required: Be sure to label each variance as F – favorable or U – unfavorable. 1. What is the predetermined fixed overhead rate for the year? 2. What was the fixed overhead budget or spending variance? 3. What is the fixed overhead volume variance?
ABC Enterprises has asked for your assistance in preparing a cash budget for the month of...
ABC Enterprises has asked for your assistance in preparing a cash budget for the month of December 2020 and has provided projected sales revenue data below: Projected sales: October 2020 $144,000 November 2020 $205,000 December 2020 $220,000 All sales are on credit with 65% collected during the month of sale, 18% collected during the month following the sale, 15% during the second month after the sale and 2% uncollectable. Required: a) Prepare the cash receipts section of a cash budget...
Although the practice is doing well, business is down 20% from last year this time. The...
Although the practice is doing well, business is down 20% from last year this time. The practice has been losing some client and is not acquiring new clients as they were a year ago. During a meeting with your representatives, they noted that there are several factors in the market that they should consider carefully in relation to the practice’s marketing strategy.
Kumar’s business was doing well and it made him a profit of $20,000 each month. He...
Kumar’s business was doing well and it made him a profit of $20,000 each month. He needed to make some modifications to his business premise and thus engaged Bob Builders to do the renovation work. He wanted it completed by 31 May. He was assured that the work would be completed in time. He was informed that the renovation work would begin immediately after Council approval for the renovations was granted and that Council approval would normally only take 15...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July....
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 75,000 Accounts receivable 58,600 Inventory 43,000 Buildings and equipment, net of depreciation 205,000 Total assets $ 381,600 Liabilities and Stockholders’ Equity Accounts payable $ 68,600 Common stock 100,000 Retained earnings 213,000 Total liabilities and stockholders’ equity $ 381,600 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July....
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 77,000 Accounts receivable 58,200 Inventory 32,800 Buildings and equipment, net of depreciation 186,000 Total assets $ 354,000 Liabilities and Stockholders’ Equity Accounts payable $ 39,000 Common stock 100,000 Retained earnings 215,000 Total liabilities and stockholders’ equity $ 354,000 Budgeting Assumptions: All sales are on account. Thirty percent of the...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT