Question

In: Accounting

Herald company, a jacket selling company, prepares its master budget for the year 2020 on a...

Herald company, a jacket selling company, prepares its master budget for the year 2020 on a quarterly basis. The budget officer has gathered the following data:

1. Estimated Sales for each quarter is $230,000. All sales are on credit and all sales are collected in the following quarter.

2. Cost of goods sold for each quarter is $100,000.

3. Variable selling and administrative expenses for each jacket are 10% sales commission.

4. Fixed selling and administrative (S&A) expenses for the year are:

Advertising $60,000
Executive salaries $110,000
Insurance $40,000
Depreciation $20,000
Total fixed S&A expenses $230,000

5. The company expects to borrow $80,000 on April, 1, 2020. No principal will be repaid during the year; Interest rate at an annual rate of 10% is due quarterly.

6. The company will declare $3,000 dividend in December 2020, which will be paid in January 2021.

The company's expected total cash receipt from sales is $690,000 and expected cash disbursements from manufacturing costs is $90,000 during the year 2020. If the year's beginning balance of cash is $25,000, what is the ending balance of cash in the year 2020?

Lebaum Corporation uses the weighted-average method in its process costing system. Data concerning the second processing department for the most recent month are listed below:

Production data:

Units in process, beginning:

   (materials 60% complete; conversion 20% complete)

400 units

Units transferred in during the month from the preceding department:

1,200 units

Units completed and transferred out during the month:

1,000 units

Units in process, ending:

   (materials 40% complete; conversion 80% complete)

? units

Cost data:

Work in process, beginning:

(consists of cost transferred in, $12,400; materials cost, $9,078; and conversion cost, $7,514)

$      28,992

Costs transferred in during the month:

$    126,000

Materials cost added during the month:

$      82,000

Conversion costs incurred during the month:

$    108,000

What is the cost of units completed and transferred out? (Choose the closest answer).

Alrex company is using an activity-based costing (ABC) system. The company produces and sells two products: Basic and Pro. The company consists of two departments: Production (where all manufacturing activities are taken) and Marketing (which engages in selling and admin activity only). The ABC system includes in unit product costs all costs easily associated with units. In addition, in the ABC system, there are four major indirect activities: Machine Setups, Special Processing, Factory Supervision, and Customer Relation.

The prices, direct material cost (DM), shipping cost and direct labor-hours (DLHs) are given below for one unit of the product, as well as the total units produced and sold.

Product

Price

DM

DLHs

Hourly Wage-DL

Shipping Cost

Units

Basic

$180

$50

1

$10

$1

6,000

Pro

$320

$80

2

$12

$4

4,000

The company collected the data for ABC as follows:

Activity Cost Pool

Activity Measure

Estimated OH cost

Activity measures used

Basic

Pro

Machine Setup

# of setups

$     472,500

60

120

Special Processing

Machine hours

$     360,000

6,000

10,000

Factory Supervision

DLH

$     224,000

Customer Relation (10 customers)

# of customers

$     240,000

The company has two major customers (A and B), who buy their products in the amounts in the table below.

Customer A B
Basic 800 2,000 units
Pro 1,200 1,000 units

How much is the ABC customer margin of customer B? (Choose the closest amount.)

Solutions

Expert Solution

Dear student, we cannot able to post solution more than one question as per our policy.

Question:

Herald company, a jacket selling company, prepares its master budget for the year 2020 on a quarterly basis. The budget officer has gathered the following data:

1. Estimated Sales for each quarter is $230,000. All sales are on credit and all sales are collected in the following quarter.

2. Cost of goods sold for each quarter is $100,000.

3. Variable selling and administrative expenses for each jacket are 10% sales commission.

4. Fixed selling and administrative (S&A) expenses for the year are:

Advertising $60,000
Executive salaries $110,000
Insurance $40,000
Depreciation $20,000
Total fixed S&A expenses $230,000

5. The company expects to borrow $80,000 on April, 1, 2020. No principal will be repaid during the year; Interest rate at an annual rate of 10% is due quarterly.

6. The company will declare $3,000 dividend in December 2020, which will be paid in January 2021.

The company's expected total cash receipt from sales is $690,000 and expected cash disbursements from manufacturing costs is $90,000 during the year 2020. If the year's beginning balance of cash is $25,000, what is the ending balance of cash in the year 2020?

Answer:

Depreciation is non cash expense and not required to cash outflows.

Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total
Sales $        230,000 $        230,000 $        230,000 $        230,000
Cash receipt from sales (Previous month's sales) $        230,000 $        230,000 $        230,000 $        690,000
Manufacturing costs $          90,000
Sales commission (230000*10%) $          23,000 $          23,000 $          23,000 $          23,000 $          92,000
Advertising (60000/4) $          15,000 $          15,000 $          15,000 $          15,000 $          60,000
Executive salaries (110000/4) $          27,500 $          27,500 $          27,500 $          27,500 $        110,000
Insurance (40000/4) $          10,000 $          10,000 $          10,000 $          10,000 $          40,000
Interest paid (80000*10%*3/12) $            2,000 $            2,000 $            2,000 $            6,000
Cash budget Annual
Beginning balance of cash $          25,000
Add: cash receipt
Cash receipt from sales $        690,000
Cash borrowed in April $          80,000
Total cash receipt $        770,000
Total cash available for disbursements $        795,000
Less: cash disbursements
Manufacturing costs $          90,000
Sales commission $          92,000
Advertising $          60,000
Executive salaries $        110,000
Insurance $          40,000
Interest paid $             6,000
Total cash disbursements $        398,000
Ending balance of cash $        397,000

Related Solutions

Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Acct Receviable 48,000 Inventory 12,6000 Buildings & Equip. (net) 214,100 Acct. Payable 18,300 Common Stock 190,000 Retained Earnings 75,400 Totals 283,700 283,700 b. Sales for March total...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Acct Receviable 48,000 Inventory 12,6000 Buildings & Equip. (net) 214,100 Acct. Payable 18,300 Common Stock 190,000 Retained Earnings 75,400 Totals 283,700 283,700 b. Sales for March total...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Acct Receviable 48,000 Inventory 12,6000 Buildings & Equip. (net) 214,100 Acct. Payable 18,300 Common Stock 190,000 Retained Earnings 75,400 Totals 283,700 283,700 b. Sales for March total...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Accounts receivable        48,000 Inventory        12,600 Buildings and equipment (net)      214,100 Accounts payable          18,300 Common Stock        190,000 Retained earnings          75,400 Totals $283,700...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Accounts receivable        48,000 Inventory        12,600 Buildings and equipment (net)      214,100 Accounts payable          18,300 Common Stock        190,000 Retained earnings          75,400 Totals $283,700...
Downton Company manufactures two products, Abby and Mansion. The company prepares its master budget on the...
Downton Company manufactures two products, Abby and Mansion. The company prepares its master budget on the basis of standard costs. The following data are for January: Standards Abby Mansion Direct materials 3 ounces at $14.50 per ounce 4 ounces at $17.30 per ounce Direct labor 5 hours at $60.50 per hour 6 hours at $81.00 per hour Variable overhead (per direct labor-hour) $48.00 $53.50 Fixed overhead (per month) $368,068 $399,360 Expected activity (direct labor-hours) 6,680 7,800 Actual results Direct material...
Hancock Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Hancock Company, a merchandising company, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the second quarter. a. As of December 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances:   Cash $ 13,100   Accounts receivable 55,800   Inventory 18,620   Buildings and equipment (net) 135,000   Accounts payable $ 47,000   Common stock 115,000   Retained earnings 60,520 $ 222,520 $ 222,520 b. Actual...
ABCD Corp prepares its master budget on a quarterly basis and has a September 30 year...
ABCD Corp prepares its master budget on a quarterly basis and has a September 30 year end. The following data and information has been prepared to help you prepare the master budget for the first quarter of the fiscal year (October thru December). Info provided as follows: 1. Actual Sales for September, 2019 and projected sales for October, November and December, 2019 and January 2020 are as follows: September $280,000 October $400,000 November $600,000 December $1,800,000 January $700,000 2. Monthly...
ABCD Corp prepares its master budget on a quarterly basis and has a September 30 year...
ABCD Corp prepares its master budget on a quarterly basis and has a September 30 year end. The following data and information has been prepared to help you prepare the master budget for the first quarter of the fiscal year (October thru December). Info provided as follows: 1. Actual Sales for September, 2019 and projected sales for October, November and December, 2019 and January 2020 are as follows: September $280,000 October $400,000 November $600,000 December $1,800,000 January $700,000 2. Monthly...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Cash $ 58,000 Accounts receivable 214,400 Inventory 60,450 Buildings and equipment (net) 368,000 Accounts payable $ 90,525 Common stock 500,000 Retained earnings 110,325 $ 700,850 $ 700,850 Actual sales...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT