| E5-14 Prepare a cash budget for two months. | |||||||||||
| Rigley Company expects to have a cash balance of $46,000 on January 1, 2017. | |||||||||||
| These are the relevant monthly budget data for the first two months of 2017. | |||||||||||
| 1. | Collection from customers: January $71,000 and February $146,000. | ||||||||||
| 2. | Payments to suppliers: January $40,000, February $75,000. | ||||||||||
| 3. | Wages: January $30,000 and February $40,000. Wages are paid in the month | ||||||||||
| they are incurred. | |||||||||||
| 4. | Administrative expenses: January $21,000 and February $24,000. These costs | ||||||||||
| include depreciation of $1,000 per month. All other costs are paid as incurred. | |||||||||||
| 5. | Selling expenses: January $15,000 and February $20,000. These costs are exclusive | ||||||||||
| of depreciation. They are paid as incurred. | |||||||||||
| 6. | Sales of short-term investments in January are expected to realize $12,000 in | ||||||||||
| cash. Rigley has a line of credit at a local bank that enables it to borrow up | |||||||||||
| to $25,000. The company want to maintain a minimum monthly cash balance | |||||||||||
| of $20,000. | |||||||||||
| Instructions | |||||||||||
| Prepare a cash budget for January and February. | |||||||||||
| NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?" . | |||||||||||
| RIGLEY COMPANY | |||||||||||
| Cash Budget | |||||||||||
| For the Two Months Ending February 28, 2017 | |||||||||||
| January | February | ||||||||||
| Beginning cash balance | Value | Value | |||||||||
| Add: | Cash receipts | ||||||||||
| Collections from customers | Value | Value | |||||||||
| Sale of short-term investments | Value | Value | |||||||||
| Total receipts | ? | ? | |||||||||
| Total available cash | ? | ? | |||||||||
| Less: Cash disbursements | |||||||||||
| Payments to suppliers | Value | Value | |||||||||
| Wages | Value | Value | |||||||||
| Administrative expenses | Value | Value | |||||||||
| Selling expenses | Value | Value | |||||||||
| Total disbursements | ? | ? | |||||||||
| Excess (deficiency) of available cash over disbursements | ? | ? | |||||||||
| Financing | |||||||||||
| Add: Borrowings | Value | Value | |||||||||
| Less: Repayments | Value | Value | |||||||||
| Ending cash balance | ? | ? | |||||||||
| After you have completed E7-14, consider the following additional question | |||||||||||
| 1. | Assume that collection from customers and payment to suppliers in January changed to $80,000 | ||||||||||
| and $55,000 respectively. Show the impact of these changes on the Cash Budget. | |||||||||||
|
SOLVE FOR MISSING VALUES AND ANSWER QUESTION 1 |
|||||||||||
In: Accounting
In: Accounting
Entries and Schedules for Unfinished Jobs and Completed Jobs
Hildreth Company uses a job order cost system. The following data summarize the operations related to production for April, the first month of operations:
| Job No. | Materials | Factory Labor | ||
| 101 | $2,610 | $2,520 | ||
| 102 | 3,180 | 3,400 | ||
| 103 | 2,110 | 1,660 | ||
| 104 | 7,150 | 6,250 | ||
| 105 | 4,540 | 4,760 | ||
| 106 | 3,310 | 3,020 | ||
| For general factory use | 890 | 3,730 | ||
| Job No. | Machine Hours | ||
| 101 | 24 | ||
| 102 | 18 | ||
| 103 | 27 | ||
| 104 | 73 | ||
| 105 | 21 | ||
| 106 | 22 | ||
| Total | 185 | ||
Required:
1. Journalize the entries to record the summarized operations. If an amount box does not require an entry, leave it blank.
| Entries | Description | Debit | Credit |
|---|---|---|---|
| a. | Materials | ||
| Accounts Payable | |||
| b. | Work in Process | ||
| Factory Overhead | |||
| Materials | |||
| Wages Payable | |||
| c. | Factory Overhead | ||
| Accounts Payable | |||
| d. | Factory Overhead | ||
| Accumulated Depreciation-Machinery and Equipment | |||
| e. | Work in Process | ||
| Factory Overhead | |||
| f. | Finished Goods | ||
| Work in Process | |||
| g. Sale | Accounts Receivable | ||
| Sales | |||
| g. Cost | Cost of Goods Sold | ||
| Finished Goods |
2. Post the appropriate entries to T accounts for Work in Process and Finished Goods, using the identifying letters as transaction codes. Insert memo account balances as of the end of the month.
| Work in Process | |||
|---|---|---|---|
| (b) | (f) | ||
| (e) | |||
| Bal. | |||
| Finished Goods | |||
|---|---|---|---|
| (f) | (g) | ||
| Bal. | |||
3. Prepare a schedule of unfinished jobs to support the balance in the work in process account.
| Hildreth Company Schedule of Unfinished Jobs |
||||||||
|---|---|---|---|---|---|---|---|---|
| Job | Direct Materials | Direct Labor | Factory Overhead | Total | ||||
| No. 104 | $ | $ | $ | $ | ||||
| No. 106 | ||||||||
| Balance of Work in Process, April 30 | $ | |||||||
4. Prepare a schedule of completed jobs on hand to support the balance in the finished goods account.
| Hildreth Company Schedule of Completed Jobs |
||||||||
|---|---|---|---|---|---|---|---|---|
| Job | Direct Materials | Direct Labor | Factory Overhead | Total | ||||
| Finished Goods, April 30 (Job 103) | $ | $ | $ | $ | ||||
In: Accounting
Entries and Schedules for Unfinished Jobs and Completed Jobs
Hildreth Company uses a job order cost system. The following data summarize the operations related to production for April, the first month of operations:
| Job No. | Materials | Factory Labor | ||
| 101 | $1,800 | $2,940 | ||
| 102 | 2,200 | 3,970 | ||
| 103 | 1,460 | 1,940 | ||
| 104 | 4,930 | 7,290 | ||
| 105 | 3,130 | 5,560 | ||
| 106 | 2,290 | 3,530 | ||
| For general factory use | 610 | 4,350 | ||
| Job No. | Machine Hours | ||
| 101 | 43 | ||
| 102 | 18 | ||
| 103 | 27 | ||
| 104 | 70 | ||
| 105 | 45 | ||
| 106 | 29 | ||
| Total | 232 | ||
Required:
1. Journalize the entries to record the summarized operations. If an amount box does not require an entry, leave it blank.
| Entries | Description | Debit | Credit |
|---|---|---|---|
| a. | Materials | ||
| Accounts Payable | |||
| b. | Work in Process | ||
| Factory Overhead | |||
| Materials | |||
| Wages Payable | |||
| c. | Factory Overhead | ||
| Accounts Payable | |||
| d. | Factory Overhead | ||
| Accumulated Depreciation-Machinery and Equipment | |||
| e. | Work in Process | ||
| Factory Overhead | |||
| f. | Finished Goods | ||
| Work in Process | |||
| g. Sale | Accounts Receivable | ||
| Sales | |||
| g. Cost | Cost of Goods Sold | ||
| Finished Goods |
2. Post the appropriate entries to T accounts for Work in Process and Finished Goods, using the identifying letters as transaction codes. Insert memo account balances as of the end of the month.
| Work in Process | |||
|---|---|---|---|
| (b) | (f) | ||
| (e) | |||
| Bal. | |||
| Finished Goods | |||
|---|---|---|---|
| (f) | (g) | ||
| Bal. | |||
3. Prepare a schedule of unfinished jobs to support the balance in the work in process account.
| Hildreth Company Schedule of Unfinished Jobs |
||||||||
|---|---|---|---|---|---|---|---|---|
| Job | Direct Materials | Direct Labor | Factory Overhead | Total | ||||
| No. 104 | $ | $ | $ | $ | ||||
| No. 106 | ||||||||
| Balance of Work in Process, April 30 | $ | |||||||
4. Prepare a schedule of completed jobs on hand to support the balance in the finished goods account.
| Hildreth Company Schedule of Completed Jobs |
||||||||
|---|---|---|---|---|---|---|---|---|
| Job | Direct Materials | Direct Labor | Factory Overhead | Total | ||||
| Finished Goods, April 30 (Job 103) | $ | $ | $ | $ | ||||
In: Accounting
Cholesterol levels are a major concern to health insurance providers. Cholesterol levels in U.S. adults average 215 with a standard deviation of 30. If the cholesterol levels of a sample of 42 U.S. adults is taken, what is the probability that the mean cholesterol level of the sample 1) Will be less than 200? 2) Will be between 205 and 225? 3) Will be greater than 220?
2. Suppose that 36% of the clients of a company use smart phones. Draw a random sample of 200 clients, what is the probability that the sample proportion is 1) Less than 0.28? 2) Greater than 0.42?
3. A bottler wishes to ensure that the average of 16 ounces of fruit juice is used to fill each bottle. In order to analyze the accuracy of the bottling process, he takes a random sample of 48 bottles. The mean weight of the juice in the sample is 15.8 ounces. Assume the population standard deviation is 0.8 ounce. Test his concern at the 5% significance level.
4. In a sample of 1022 U.S. adults, 73% say that they are not happy with the current investment climate. Is there evidence that the percentage has significantly decreased from the 74% reported previously? Do the test at the 1% level.
5. The percentage of bills being paid by Medicare has been 31%. An examination of 8368 recent bills reveals that 32% of these bills are being paid by Medicare. Is this evidence of a change in the percentage of bills being paid by Medicare? Do the test at the 10% level.
In: Statistics and Probability
Companies sometimes offer their customers a discount on their purchase if they pay early. What is the benefit for the company to take a reduced amount on these purchases and from the customer’s point of view is it beneficial for them to take the discount. What factors does the customer have to consider when deciding to take the discount?
In: Accounting
Explain in technical details why the Lagrange multiplier is crucially used in analysing the theory of the consumer .Further as a managerial economics student ,show how you can apply this technique to advise your company to make sales without making loses and affecting your customers negatively
In: Economics
In: Operations Management
1. Under absorption costing, a company had the following unit costs when 8,000 units were
produced.
|
Direct labor |
$ |
8.50 |
per unit |
|
Direct material |
$ |
9.00 |
per unit |
|
Variable overhead |
$ |
6.75 |
per unit |
|
Fixed overhead ($60,000/8,000 units) |
$ |
7.50 |
per unit |
|
Total production cost |
$ |
31.75 |
per unit |
Compute the total production cost per unit under variable costing if 25,000 units had been produced.
A) $31.75
B) $27.25
C) $26.25
D) $24.25
E) $17.50
2. When evaluating a special order, management should:
A) Only accept the order if the incremental revenue exceeds all product costs.
B) Only accept the order if the incremental revenue exceeds fixed product costs.
C) Only accept the order if the incremental revenue exceeds total variable product costs.
D) Only accept the order if the incremental revenue exceeds full absorption product costs.
E) Only accept the order if the incremental revenue exceeds regular sales revenue.
3. Which of the following best describes costs assigned to the product under the absorption
costing method?
Direct labor (DL)
Direct materials (DM)
Variable selling and administrative (VSA)
Variable manufacturing overhead (VOH)
Fixed selling and administrative (FSA)
Fixed manufacturing overhead (FOH)
A) DL, DM, VSA, and VOH.
B) DL, DM, and VOH.
C) DL, DM, VOH, and FOH.
D) DL and DM.
E) DL, DM, FSA, and FOH.
4. Which of the following best describes costs assigned to the product under the variable
costing method?
Direct labor (DL)
Direct materials (DM)
Variable selling and administrative (VSA)
Variable manufacturing overhead (VOH)
Fixed selling and administrative (FSA)
Fixed manufacturing overhead (FOH)
A) DL, DM, VSA, and VOH.
B) DL, DM, and VOH.
C) DL, DM, VOH, and FOH.
D) DL and DM.
E) DL, DM, FSA, and FOH.
12. Howley Company has the following information for April:
Sales $912,000
VC of goods sold 474,000
FC – mfg. 82,000
VC – selling & adm. 238,000
FC – selling & adm. 54,700
a, Operating Income for Howley during the month of April.
In: Accounting
Create the 2018 budget for Buy-Right Bike Store (BRBS). Add a worksheet to your Project Excel workbook for BRBC Budgeted Income Statement and create the 2018 budget using the following information.
Budgeted Sales of Bike C: Online 75,000 bikes; instore 5,000 bikes.
Bike C is purchased from Built-Right Bike Company, a sister company in the Biltmore Bicycle Corporation (BMBC), for $52 and is sold for $104.
Inventory:
Beginning inventory: $ 52,000
Purchases 4,108,000
Sales ?
Ending Inventory $ 52,000
Employees:
Managerial Staff:
Manager: 1 FTE, $45,000 annual salary plus 20% benefits
Bookkeeper: 1 FTE, $40,000 annual salary plus 20% benefits
Purchasing & Receiving Supervisor: 1 FTE, $35,000 annual salary plus 20% benefits
Other staff:
Warehouse: 2.5 FTEs make $15 per hour plus 17% benefits
Online sales staff: 2 FTEs, $15 per hour plus 17% benefits (no commission)
Store Hours:
Monday – Saturday 10:00 am – 6:00 pm
2 sales clerks work from 10-3 M-F
3 sales clerks work from 3-6 M-F
4 sales clerks work 10-6 on Saturdays
Sales clerks earn $15 per hour plus 17% benefits
Instore sales staff share commission equal to 10% of instore sales.
Budgeted Utility cost: $13,200
Budgeted Marketing Cost: $175,000
Contributions & community service: 10% of instore revenue
Other costs (includes depreciation, insurance, etc): $1,300,000
Income tax 29% of Net Revenue
In: Accounting