Required information

Problem 14-23 Preparing a master budget for retail company with no beginning account balances LO 14-2, 14-3, 14-4, 14-5, 14-6

[The following information applies to the questions displayed below.]

Finch Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, 2019. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks:

Problem 14-23 Part 1

Required

1. October sales are estimated to be $340,000, of which 35 percent will be cash and 65 percent will be credit. The company expects sales to increase at the rate of 20 percent per month. Prepare a sales budget.

2. The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts.

3. The cost of goods sold is 70 percent of sales. The company desires to maintain a minimum ending inventory equal to 20 percent of the next month’s cost of goods sold. However, ending inventory of December is expected to be $12,500. Assume that all purchases are made on account. Prepare an inventory purchases budget.

4. The company pays 60 percent of accounts payable in the month of purchase and the remaining 40 percent in the following month. Prepare a cash payments budget for inventory purchases.

5. Budgeted selling and administrative expenses per month follow:

1. *The capital expenditures budget indicates that Finch will spend $133,000 on October 1 for store fixtures, which are expected to have a $25,000 salvage value and a two-year (24-month) useful life.

Use this information to prepare a selling and administrative expenses budget.

6. Utilities and sales commissions are paid the month after they are incurred; all other expenses are paid in the month in which they are incurred. Prepare a cash payments budget for selling and administrative expenses.

7. Finch borrows funds, in increments of $1,000, and repays them on the last day of the month. Repayments may be made in any amount available. The company also pays its vendors on the last day of the month. It pays interest of 2 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $17,000 cash cushion. Prepare a cash budget.

8. Prepare a pro forma income statement for the quarter.

9. Prepare a pro forma balance sheet at the end of the quarter.

10. Prepare a pro forma statement of cash flows for the quarter.

Compute and Interpret Altman's Z-scores Following is selected financial information for Netflix, for 2018 and 2017. $ thousands, except per share data 2018 2017 Current assets $9,694,135 $7,669,974 Current liabilities 6,487,320 5,466,312 Total assets 25,974,400 19,012,742 Total liabilities 20,735,635 15,430,786 Shares outstanding 436,598,597 433,392,686 Retained earnings 2,942,359 1,731,117 Stock price per share 267.66 191.96 Sales 15,794,341 11,692,713 Earnings before interest and taxes 1,605,226 838,679 Compute and interpret Altman Z-scores for the company for both years. (Do not round until your final answer; then round your answers to two decimal places.) 2018 z-score = Answer 2017 z-score = Answer Which of the following best describes the company's likelihood to go bankrupt given the z-score in 2017 compared to 2018. The z-score in 2018 increased. Z-scores for both years are in the gray area indicating some risk of bankruptcy. The z-score in 2018 increased, which suggests the company's risk of bankruptcy has increased. The z-score in 2018 increased. Z-scores for both years indicate low bankruptcy potential in the short term. The z-score in 2018 decreased, which suggests the company's risk of bankruptcy has decreased.

[The following information applies to the questions displayed below.]

The following data pertain to Lawn Master Corporation’s top-of-the-line lawn mower.

To achieve a target price of $541 per lawn mower, the markup percentage is 12.7 percent on total unit cost.

Required:

1. What is the fixed selling and administrative cost allocated to each unit of Lawn Master’s top-of-the-line mower? (Do not round your intermediate computations. Round your final answer to the nearest dollar amount.)
2. For each of the following cost bases, develop a cost-plus pricing formula that will result in a target price of $541 per mower: (Round your percentage answers to 2 decimal places (i.e., .1234 should be entered as 12.34).)

Skip Company produces a product called Lem. The standard direct material cost to produce one unit of Lem is four quarts of raw material at $2.50 per quart. During May, 5,880 quarts of raw material were purchased at a cost of $14,112. All the purchased material was used to produce 1,400 units of Lem.

a. Compute the material price variance and material quantity variance for May.
Note: Do not use a negative sign with your answers.

b. Assume the same facts except that Skip Company purchased 8,400 quarts of material at the previously calculated cost per quart, but used only 5,880 quarts. Compute the material price variance and material quantity variance for May, assuming that Skip identifies variances at the earliest possible time.
Note: Do not use a negative sign with your answers.

c. Prepare the journal entries to record the material price and usage variances calculated in (b).
Note: List any multiple debits or any multiple credits in alphabetical order by account name.

Please answer all parts of the question.

Contribution Margin, Break-Even Sales, Cost-Volume-Profit Chart, Margin of Safety, and Operating Leverage

Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these estimates is as follows:

It is expected that 6,480 units will be sold at a price of $360 a unit. Maximum sales within the relevant range are 8,000 units.

Required:

1. Prepare an estimated income statement for 20Y7.

2. What is the expected contribution margin ratio? Round to the nearest whole percent.
%

3. Determine the break-even sales in units and dollars.

4. Construct a cost-volume-profit chart on your own paper. What is the break-even sales?
$

5. What is the expected margin of safety in dollars and as a percentage of sales?

6. Determine the operating leverage. Round to one decimal place.

Break-Even Sales and Sales Mix for a Service Company Zero Turbulence Airline provides air transportation services between Los Angeles, California; and Kona, Hawaii. A single Los Angeles to Kona round-trip flight has the following operating statistics: Fuel $5,640 Flight crew salaries 4,320 Airplane depreciation 2,040 Variable cost per passenger—business class 55 Variable cost per passenger—economy class 45 Round-trip ticket price—business class 555 Round-trip ticket price—economy class 295 It is assumed that the fuel, crew salaries, and airplane depreciation are fixed, regardless of the number of seats sold for the round-trip flight. If required round the answers to nearest whole number. a. Compute the break-even number of seats sold on a single round-trip flight for the overall product, E. Assume that the overall product is 20% business class and 80% economy class seats. Total number of seats at break-even seats b. How many business class and economy class seats would be sold at the break-even point? Business class seats at break-even seats Economy class seats at break-even seats

Mills Corporation acquired as a long-term investment $235 million of 8% bonds, dated July 1, on July 1, 2021. Company management has classified the bonds as an available-for-sale investment. The market interest rate (yield) was 6% for bonds of similar risk and maturity. Mills paid $270 million for the bonds. The company will receive interest semiannually on June 30 and December 31. As a result of changing market conditions, the fair value of the bonds at December 31, 2021, was $260 million.

1. & 2. Prepare the journal entry to record Mills’ investment in the bonds on July 1, 2021 and interest on December 31, 2021, at the effective (market) rate.
3. At what amount will Mills report its investment in the December 31, 2021, balance sheet?
4. Suppose Moody's bond rating agency upgraded the risk rating of the bonds, and Mills decided to sell the investment on January 2, 2022, for $280 million. Prepare the journal entries required on the date of sale.

4.1 Record the fair-value adjustment.

4.2 Record any reclassification adjustment.

4.3 Record the sale of the investment by Mills.

Board Company has a foreign subsidiary that began operations at the start of 2017 with assets of 139,000 kites (the local currency unit) and liabilities of 68,000. During this initial year of operation, the subsidiary reported a profit of 33,000 kites. It distributed two dividends, each for 5,700 kites with one dividend declared on March 1 and the other on October 1. Applicable exchange rates for 1 kite follow:

1. Assume that the kite is this subsidiary’s functional currency. What translation adjustment would Board report for the year 2017?

2. Assume that on October 1, 2017, Board entered into a forward exchange contract to hedge the net investment in this subsidiary. On that date, Board agreed to sell 270,000 kites in three months at a forward exchange rate of $0.72/1 kite. Prepare the journal entries required by this forward contract.

3. Compute the net translation adjustment for Board to report in accumulated other comprehensive income for the year 2017 under this second set of circumstances.

Bunnell Corporation is a manufacturer that uses job-order costing. On January 1, the company’s inventory balances were as follows:

The company applies overhead cost to jobs on the basis of direct labor-hours. For the current year, the company’s predetermined overhead rate of $16.25 per direct labor-hour was based on a cost formula that estimated $650,000 of total manufacturing overhead for an estimated activity level of 40,000 direct labor-hours. The following transactions were recorded for the year:

1. Raw materials were purchased on account, $510,000.
2. Raw materials used in production, $480,000. All of of the raw materials were used as direct materials.
3. The following costs were accrued for employee services: direct labor, $600,000; indirect labor, $150,000; selling and administrative salaries, $240,000.
4. Incurred various selling and administrative expenses (e.g., advertising, sales travel costs, and finished goods warehousing), $367,000.
5. Incurred various manufacturing overhead costs (e.g., depreciation, insurance, and utilities), $500,000.
6. Manufacturing overhead cost was applied to production. The company actually worked 41,000 direct labor-hours on all jobs during the year.
7. Jobs costing $1,680,000 to manufacture according to their job cost sheets were completed during the year.
8. Jobs were sold on account to customers during the year for a total of $2,800,000. The jobs cost $1,690,000 to manufacture according to their job cost sheets.

   TRANSACTION	GENERAL JOURNAL	DEBIT	CREDIT

Bonita Company sells 8% bonds having a maturity value of $1,420,000 for $1,312,340. The bonds are dated January 1, 2020, and mature January 1, 2025. Interest is payable annually on January 1.

Determine the effective-interest rate. (Round answer to 0 decimal places, e.g. 18%.)

eTextbook and Media

Set up a schedule of interest expense and discount amortization under the effective-interest method. (Round intermediate calculations to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places, e.g. 38,548.)

[The following information applies to the questions displayed below.]

Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March.

4. Compute gross profit earned by the company for each of the four costing methods. For specific identification, the March 9 sale consisted of 50 units from beginning inventory and 180 units from the March 5 purchase; the March 29 sale consisted of 30 units from the March 18 purchase and 70 units from the March 25 purchase. (Round weighted average cost per unit to two decimals and final answers to nearest whole dollar.)

1. Saguaro Inc. owns 80% of Sequoia Inc. On January 1, 2018, Sequoia sign a note and took a loan from Saguaro for the amount of $1,000,000 with an annual interest rate of 8%. No interest payment has been made. To prepare the consolidated financial statement for 2018 which of the following consolidating entry should be made?

a. debit to note payable in amount of $1,000,000

b. credit to note payable in the amount of $1,000,000

c. debit to note receivable in the amount of $1,000,000

d. credit to note receivable in the amount of $800,000

e. debit to note payable in the amount of $800,000

2. Saguaro Inc. owns 80% of Sequoia Inc. On January 1, 2018, Sequoia sign a note and took a loan from Saguaro for the amount of $1,000,000 with an annual interest rate of 8%. No interest payment has been made. To prepare the consolidated financial statement for 2018 which of the following consolidating entry should be made?

a. debit to interest receivable and credit to interest payable in amount of $80,000

b. debit to interest expense and credit to interest income in amount of $80,000

c. no consolidating entry needed in regard to interest payable and interest receivable

d. debit to interest income and credit to interest expense in amount of $80,000

e. no consolidating entry needed with regard to interest income and expense

The following information applies to the questions displayed below.]

Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March.

3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, the March 9 sale consisted of 50 units from beginning inventory and 180 units from the March 5 purchase; the March 29 sale consisted of 30 units from the March 18 purchase and 70 units from the March 25 purchase.

Endless Mountain Company manufactures a single product that is popular with outdoor recreation enthusiasts. The company sells its product to retailers throughout the northeastern quadrant of the United States. It is in the process of creating a master budget for 2017 and reports a balance sheet at December 31, 2016 as follows:

The company’s chief financial officer (CFO), in consultation with various managers across the organization has developed the following set of assumptions to help create the 2017 budget:

1. The budgeted unit sales are 12,000 units, 37,000 units, 15,000 units, and 25,000 units for quarters 1-4, respectively. Notice that the company experiences peak sales in the second and fourth quarters. The budgeted selling price for the year is $32 per unit. The budgeted unit sales for the first quarter of 2018 is 13,000 units.
2. All sales are on credit. Uncollectible accounts are negligible and can be ignored. Seventy-five percent of all credit sales are collected in the quarter of the sale and 25% are collected in the subsequent quarter.
3. Each quarter’s ending finished goods inventory should equal 15% of the next quarter’s unit sales.
4. Each unit of finished goods requires 3.5 yards of raw material that costs $3.00 per yard. Each quarter’s ending raw materials inventory should equal 10% of the next quarter’s production needs. The estimated ending raw materials inventory on December 31, 2017 is 5,000 yards.
5. Seventy percent of each quarter’s purchases are paid for in the quarter of purchase. The remaining 30% of each quarter’s purchases are paid in the following quarter.
6. Direct laborers are paid $18 an hour and each unit of finished goods requires 0.25 direct labor-hours to complete. All direct labor costs are paid in the quarter incurred.
7. The budgeted variable manufacturing overhead per direct labor-hour is $3.00. The quarterly fixed manufacturing overhead is $150,000 including $20,000 of depreciation on equipment. The number of direct labor-hours is used as the allocation base for the budgeted plantwide overhead rate. All overhead costs (excluding depreciation) are paid in the quarter incurred.
8. The budgeted variable selling and administrative expense is $1.25 per unit sold. The fixed selling and administrative expenses per quarter include advertising ($25,000), executive salaries ($64,000), insurance ($12,000), property tax ($8,000), and depreciation expense ($8,000). All selling and administrative expenses (excluding depreciation) are paid in the quarter incurred.
9. The company plans to maintain a minimum cash balance at the end of each quarter of $30,000. Assume that any borrowings take place on the first day of the quarter. To the extent possible, the company will repay principal and interest on any borrowings on the last day of the fourth quarter. The company’s lender imposes a simple interest rate of 3% per quarter on any borrowings.
10. Dividends of $15,000 will be declared and paid in each quarter.
11. The company uses a last-in, first-out (LIFO) inventory flow assumption. This means that the most recently purchased raw materials are the “first-out” to production and the most recently completed finished goods are the “first-out” to customers.

ALL I NEED HELP WITH IS FILLING OUT THE CHART BELOW :)

Prepare the ending finished goods inventory budget at December 31, 2017. (Round your answers to 2 decimal places.)