Badlands, Inc. manufactures a household fan that sells for $25 per unit. All sales are on account, with 30 percent of sales collected in the month of sale and 70 percent collected in the following month. The data that follow were extracted from the company’s accounting records.
Badlands maintains a minimum cash balance of $20,000. Total payments in January 20x1 are budgeted at $220,000.
A schedule of cash collections for January and February of 20x1 revealed the following receipts for the period:
| Cash Receipts | ||||||
| January | February | |||||
| From December 31 accounts receivable | $ | 126,000 | ||||
| From January sales | 87,000 | $ | 133,000 | |||
| From February sales | 75,000 | |||||
March 20x1 sales are expected to total 8,500 units.
Finished-goods inventories are maintained at 30 percent of the following month’s sales.
The December 31, 20x0, balance sheet revealed the following selected figures: cash, $23,600; accounts receivable, $126,000; and finished goods, $24,000.
Required:
Determine the number of units that Badlands sold in December 20x0.
Compute the sales revenue for March 20x1.
Compute the total sales revenue to be reported on Badlands’ budgeted income statement for the first quarter of 20x1.
Determine the accounts receivable balance to be reported on the March 31, 20x1, budgeted balance sheet.
Calculate the number of units in the December 31, 20x0, finished-goods inventory.
Calculate the number of units of finished goods to be manufactured in January 20x1.
Calculate the financing required in January, if any, to maintain the firm’s minimum cash balance.
In: Accounting
The following is the ending balances of accounts at December 31,
2018 for the Weismuller Publishing Company.
| Account Title | Debits | Credits | ||||
| Cash | 77,000 | |||||
| Accounts receivable | 172,000 | |||||
| Inventories | 291,000 | |||||
| Prepaid expenses | 160,000 | |||||
| Machinery and equipment | 332,000 | |||||
| Accumulated depreciation—equipment | 116,000 | |||||
| Investments | 152,000 | |||||
| Accounts payable | 66,000 | |||||
| Interest payable | 26,000 | |||||
| Deferred revenue | 86,000 | |||||
| Taxes payable | 36,000 | |||||
| Notes payable | 230,000 | |||||
| Allowance for uncollectible accounts | 22,000 | |||||
| Common stock | 406,000 | |||||
| Retained earnings | 196,000 | |||||
| Totals | 1,184,000 | 1,184,000 | ||||
Additional information:
Prepaid expenses include $132,000 paid on December 31, 2018, for a two-year lease on the building that houses both the administrative offices and the manufacturing facility.
Investments include $36,000 in Treasury bills purchased on November 30, 2018. The bills mature on January 30, 2019. The remaining $116,000 includes investments in marketable equity securities that the company intends to sell in the next year.
Deferred revenue represents customer prepayments for magazine subscriptions. Subscriptions are for periods of one year or less.
The notes payable account consists of the following:
a $46,000 note due in six months.
a $106,000 note due in six years.
a $78,000 note due in three annual installments of $26,000 each, with the next installment due August 31, 2019.
The common stock account represents 406,000 shares of no par value common stock issued and outstanding. The corporation has 700,000 shares authorized.
Required:
Prepare a classified balanced sheet for the Weismuller Publishing
Company at December 31, 2018. (Amounts to be deducted
should be indicated by a minus sign.)
In: Accounting
Assume that a bus company increased costs and fears that it will
make a loss. What should it do, if to rise the fares may be a wrong
policy.
To help it decide what to do it commissions a survey to estimate
passenger demand at three different fares: the current face of 10c
per km, a higher fare of 12c per km, and a lower fare of 8c. The
results of the survey are shown in the first two columns:
| Fares | Estimated Demand | Total Revenue | Old total cost | New total cost | ||||
| 8 | 6 | 480000 | 360000 | 440000 | ||||
| 10 | 4 | 400000 | 360000 | 440000 | ||||
| 12 | 3 | 360000 | 360000 | 440000 | ||||
Demand turns to be elastic. TR can be increased by reducing the price from current 10 to 8$.
What will happen to the company profits? Its profit is the difference between the total revenue from passengers and its total costs of operating the service. If buses are currently under-utilised , then is possible that the extra passengers can be carried without the need for extra buses with no extra cost..
At the fare of 10c , old profit was 40000. After the rase, a 10c now gives a loss of 40.000$. By raising the fare to 12c- loss increased to 80000$.
Questions:
1) Estimate the price elasticity of demand between 8c and 10c and between 10c and 12c. Show all detailed calculations.
2) 10c fare the best fare originally? Explain your answer detailed.
3) If the company considers lowering the fare to 6c and estimates the demand will be 8.5 million passenger km. What is your opinion, it is good idea? How should it decide?
In: Economics
| debit | credit | |
| cash | 6900 | |
| accounts receivable | 4500 | |
| prepaid rent | 6300 | |
| supplies | 2250 | |
| equipment | 18000 | |
| accumulated depreciation | 900 | |
| unearned revenue | 1500 | |
| notes payable | 10 000 | |
| contributed capital | 8000 | |
| retained earnings, 1 april | 12200 | |
| service revenue | 11200 | |
| advertising expense | 650 | |
| depreciation expense | 900 | |
| interest expense | 150 | |
| rent expense | 2100 | |
|
salaries expense dividends totals |
1700 350 43800 |
43800 |
Additional Information:
i Rent expires (is used up) at a rate of $700 per month.
ii Monthly depreciation on equipment is $300.
iii Interest on the 6 per cent promissory note is
paid quarterly on
1 April, 1 July, 1 October and 1 January.
iv Performed services for which payment was received in April– $800.
v Received electricity bill to be paid next month – $500.
vi Services to customers earned during June but unrecorded at 30 June, $2500
. vii Supplies on hand totaled $1500 at 30 June.
viii Owed employees for salaries for the last week of June to
be
paid in July – $800
. ix Prime Realty prepares adjusting entries each quarter adjustments were last made on 31 march
Required
a Prepare all adjusting journal entries for the quarter
ending 30 June.
b Post journal entries to T-accounts using totals on
the unadjusted trial balance as the opening balances
c Prepare an adjusted trial balance as of 30 June
In: Accounting
The Gourmand Cooking School runs short cooking courses at its small campus. Management has identified two cost drivers it uses in its budgeting and performance reports—the number of courses and the total number of students. For example, the school might run two courses in a month and have a total of 61 students enrolled in those two courses. Data concerning the company’s cost formulas appear below:
| Fixed Cost per Month | Cost per Course | Cost per Student |
|||||
| Instructor wages | $ | 2,980 | |||||
| Classroom supplies | $ | 280 | |||||
| Utilities | $ | 1,240 | $ | 75 | |||
| Campus rent | $ | 4,800 | |||||
| Insurance | $ | 2,200 | |||||
| Administrative expenses | $ | 3,600 | $ | 44 | $ | 5 | |
For example, administrative expenses should be $3,600 per month plus $44 per course plus $5 per student. The company’s sales should average $890 per student.
The company planned to run four courses with a total of 61 students; however, it actually ran four courses with a total of only 59 students. The actual operating results for September appear below:
| Actual | ||
| Revenue | $ | 51,390 |
| Instructor wages | $ | 11,200 |
| Classroom supplies | $ | 16,930 |
| Utilities | $ | 1,950 |
| Campus rent | $ | 4,800 |
| Insurance | $ | 2,340 |
| Administrative expenses | $ | 3,507 |
Required:
Prepare a flexible budget performance report that shows both revenue and spending variances and activity variances for September. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting
Hermosa, Inc., produces one model of mountain bike. Partial
information for the company follows:
| Number of bikes produced and sold | 480 | 760 | 940 | ||||||||||||||||||||||||||||||||||||||||||
| Total costs | |||||||||||||||||||||||||||||||||||||||||||||
| Variable costs | $ | 115,680 | $ | ? | $ | ? | |||||||||||||||||||||||||||||||||||||||
| Fixed costs per year | ? | ? | ? | ||||||||||||||||||||||||||||||||||||||||||
| Total costs | ? | ? | ? | ||||||||||||||||||||||||||||||||||||||||||
| Cost per unit | |||||||||||||||||||||||||||||||||||||||||||||
| Variable cost per unit | ? | ? | ? | ||||||||||||||||||||||||||||||||||||||||||
| Fixed cost per unit | ? | ? | ? | ||||||||||||||||||||||||||||||||||||||||||
| Total cost per unit | ? | $ | 520.75 | ? | |||||||||||||||||||||||||||||||||||||||||
|
Required:
|
|||||||||||||||||||||||||||||||||||||||||||||
2. Calculate Hermosa’s contribution margin ratio
and its total contribution margin at each sales level indicated in
the table assuming the company sells each bike for $700.
(Round your percentage answers to 2 decimal places. (i.e.
.1234 should be entered as 12.34%.))
|
4. Calculate Hermosa’s break-even point in units and sales revenue. (Round your answers to the nearest whole number.)
|
In: Accounting
Carr Company has the following ledger accounts and adjusted balances as of December 31, 2019. All accounts have normal balances. Carr’s income tax rate is 20%. Carr has 300,000 shares of Common Stock authorized, 100,000 shares of Common Stock issued, and 95,000 shares of Common Stock outstanding.
Accounts Payable……………………………. 58,500
Accounts Receivable………………………… 405,000
Accumulated Depreciation-Building………… 112,500
Accumulated Depreciation-Equipment………. 90,000
Administrative Expenses……………………. 90,000
Allowance for Doubtful Accounts…………… 45,000
Bonds Payable……………………………….. 400,000
Building……………………………………..1,125,000
Cash…………………………………………. 58,500
Common Stock……………………………… 600,000
Cost of Goods Sold…………………………. 855,000
Discount on Bonds Payable………………… 10,000
Dividends…………………………………… 30,000
Equipment…………………………………… 435,000
Income from Operations of Division X…….. 90,000 (Division X is a component of Carr Company)
Interest Revenue…………………………….. 60,000
Inventory……………………………………...630,000
Land (held for future use)...…………………. 450,000
Land (used for building)…………………….. 247,500
Loss from Sale of Division X...........................180,000 (Division X is a component of Carr Company)
Loss on Sale of Investments.……………….. .. 22,500
Mortgage Payable …………..………………. 562,500*
Paid-In Capital in Excess of Par……………...396,000
Prepaid Rent…………………………………. 22,500**
Retained Earnings, January 1, 2019………… 562,500
Sales Discounts………………………………. 45,000
Sales Returns and Allowances……………….. 75,000
Sales Revenue……………………………...2,302,500
Selling Expenses……………………………. 292,500
Trademark…………………………………… 67,500
Treasury Stock………………………………. 60,000
*$40,000 of the principal comes due in 2019.
**Two years rent on offsite document storage paid in advance.
Instructions: Use this information to prepare a multiple-step income statement, a retained earnings statement, and a classified balance sheet.
In: Accounting
The company is considering the introduction of a new product that is expected to reach sales of $10 million in its first full year and $13 million of sales in the second and third years. Thereafter, annual sales are expected to decline to two-thirds of peak annual sales in the fourth year and one-third of peak sales in the fifth year. No more sales are expected after the fifth year. The CGS is about 60% of the sales revenues in each year. The GS&A expenses are about 23.5% of the sales revenue. Tax on profits is to be paid at a 40% rate. A capital investment of $0.5 million is needed to acquire production equipment. No salvage value is expected at the end of its five-year useful life. This investment is to be fully depreciated on a straight-line basis over five years. In addition, working capital is needed to support the expected sales in an amount equal to 27% of the sales revenue. This working capital investment must be made at the beginning of each year to build up the needed inventory and implement the planned sales program. Furthermore, during the first year of sales activity, a one-time product introductory expense of $200,000 is incurred. Approximately $1.0 million has already been spent promoting and test marketing the new product.
a. Formulate a multiyear income statement to estimate the cash flows throughout its five-year life cycle.
b. Assuming a 20% discount rate, what is the new product’s NPV?
c. Should the company introduce the new product?
In: Accounting
1. The entry to record interest expense on a bank loan payable is a
| debit to interest expense and credit to note payable. |
| debit to note payable and credit to interest revenue. |
| debit to interest payable and credit to interest revenue. |
| debit to interest expense and credit to interest payable. |
2.Which of the following statements is true?
| If any portion of a non-current liability is to be paid in the next year, the entire debt should be classified as a current liability. |
| “Current maturities of non-current debt” refers to the amount of interest on notes payable that must be paid in the current year. |
| Even though current and non-current debt must be shown separately on the statement of financial position, it is not necessary to prepare a journal entry to recognize this. |
| A non- current liability is an obligation that is expected to be paid within one year. |
3.Roofer’s Inc. had an operating line of credit of $100,000 and overdrew its bank balance to result in a negative cash balance of $33,000 at year-end. This would be reported in the statement of financial position as
| a current liability of $33,000. |
| a non-current liability of $67,000. |
| a current asset of $67,000. |
| a current asset of $(33,000). |
4.Which of the following statements is true?
| Liquidity ratios measure a company’s long-term ability to pay debt. |
| Solvency ratios measure a company’s ability to repay current debt. |
| A high liquidity ratio generally indicates that a company has a greater ability to meet its current obligations. |
| Solvency ratios measure a company’s ability to survive on a short-term basis. |
In: Accounting
PROBLEM ONE The following information pertains to Life Corporation
Month Sales (units) Sales (dollars)
July 1,500 $30,000
August 1,700 34,000
September 1,600 32,000
October 1,700 40,800
November 2,100 54,600
December 2,350 51,700
January 2,300 57,000
February 1,900 51,000
March 1,750 44,000
April 1,600 41,600
May 1,500 30,000
June 1,400 32,200
Of sales, 30% are in cash with the remainder on account.
Accounts Receivable is collected from customers in the following manner:
Month of sale 30%
Month following sale 60%
Second month following sale 10%
Life Corporation desires ending inventory for finished goods to be 30% of next month’s sales.
Each unit requires three pounds of material, each pound costs $2.75. Life Corporation desires ending inventory of raw materials should be 50% of next month’s needs. Materials are purchased on account. Payments are 40% in the month of purchase with the remainder paid in the following month. The previous month’s ending Accounts Payable balance was $11,162. In addition, each unit requires one hour of labor, each labor hour costs $15.
REQUIRED:
1. Prepare a Revenue budget for December, including revenue, cash collections, and accounts receivable.
2. Prepare a Production Budget for December.
3. Prepare a Raw Materials Purchases Budget for December, including cash disbursements.
4. Prepare the Direct Labor Budget including payments.
In: Accounting