Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Dell & Company makes and sells computer components. Sales in October, November and December 2019 were $1,600,000, $1,800,000 and $1,400,000 respectively. All sales are on

Dell & Company makes and sells computer components.

Sales in October, November and December 2019 were $1,600,000, $1,800,000 and

$1,400,000 respectively. All sales are on credit. Collections from debtors are as follows: 40% in the month following the sale, 30% in the second month following the sale, and 20% in the third month following the sale. The remaining 10% are uncollectable.

The data below relates to the production and sales of its product for January, February and March 2020:

January

February

March

Direct labour hours per unit

6.0

5.5

5.5

Direct labour hourly rate

$ 9

$ 10

$ 10

Direct materials cost per unit

$ 15

$ 16

$ 16

Estimated sales

15,000 units

16,000 units

18,000 units

Selling price per unit

$ 100

$ 120

$ 120

Dell expects to have 5,000 units in inventory on 31 December 2019, and has a policy of carrying 25% of the following months projected sales in inventory.

Required:

  1. Prepare the following budgets for Dell & Company for January and February 2020. Show all workings and calculations:

  1. Production Budget (in units)

  1. Direct Labour Budget (in hours)

  1. Budget (in dollars)

  1. Sales Budget (in dollars)

  1. Calculate the budgeted Contribution Margin for January and February 2020. Show all workings and calculations.

  1. Calculate the budgeted receipts (collections) from debtors for January and February 2020. Show all workings and calculations.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Compilation Of University Level Assignments Marketing Audit Approach

Authors: Emeka Anyaduba

1st Edition

1475098057, 978-1475098051

More Books

Students also viewed these Accounting questions