In: Accounting
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.)
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 |