Questions
Financial Statements The following amounts were taken from the accounting records of Padget Home Services, Inc.,...

Financial Statements

The following amounts were taken from the accounting records of Padget Home Services, Inc., as of December 31, 20Y7. Padget Home Services began its operations on January 1, 20Y7.

Cash $ 60,000
Common stock 75,000
Dividends 15,000
Fees earned 620,000
Interest expense 4,800
Land 215,000
Miscellaneous expense 10,200
Notes payable 80,000
Rent expense 70,000
Salaries expense 272,000
Taxes expense 43,000
Utilities expense 85,000

2. Prepare a statement of stockholders’ equity for the year ending December 31, 20Y7. If your answer is zero enter "0".

Padget Home Services, Inc.
Statement of Stockholders’ Equity
For the Year Ending December 31, 20Y7
Common Stock Retained Earnings Total
Balances, Jan. 1, 20Y7 $ $ $
Issued common stock
Net income
Dividends
Balances, Dec. 31, 20Y7 $ $ $

In: Accounting

Flip Flop Inc. (FFI) has a capacity to manufacture up to 100,000 flip flops annually in...

Flip Flop Inc. (FFI) has a capacity to manufacture up to 100,000 flip flops annually in Canada. For next year, expected production and sales are 80,000 units with sale price of $10 per unit. The following costs are expected:

Production and sales

80,000 units

Direct materials used

120,000 $

Direct labour                           

  80,000

MOH variable

120,000

MOH fixed

280,000

Selling expenses variable

  64,000

Selling expenses fixed

  56,000

FFI received the following offers:

1.              Africa Imports (AI) would like to purchase 10,000 units for $8.70 $ sale price per unit.

2.              China Imports (CI) would like to purchase 20,000 units for $6.60 sale price per unit.

There will be no selling expenses on AI and CI orders. There will be no impact on regular sales in Canada.

a)              Calculate the impact on FFI operating income if AI order is accepted.

b)              Calculate the impact on FFI operating income if CI order is accepted.

c)              Which offer should FFI accept? Why?

d)              For the offer you recommend in c) above, mention and explain two qualitative factors FFI should consider before making the final decision.

In: Accounting

Manufacturing Income Statement, Statement of Cost of Goods Manufactured Several items are omitted from the income...

  1. Manufacturing Income Statement, Statement of Cost of Goods Manufactured

    Several items are omitted from the income statement and cost of goods manufactured statement data for two different companies for the month of December.

    On
    Company
    Off
    Company
    Materials inventory, December 1 $76,840 $102,970
    Materials inventory, December 31 (a) 116,360
    Materials purchased 195,170 (a)
    Cost of direct materials used in production 205,930 (b)
    Direct labor 289,690 231,680
    Factory overhead 89,900 115,330
    Total manufacturing costs incurred in December (b) 666,220
    Total manufacturing costs 733,050 914,380
    Work in process inventory, December 1 147,530 248,160
    Work in process inventory, December 31 124,480 (c)
    Cost of goods manufactured (c) 660,040
    Finished goods inventory, December 1 129,860 115,330
    Finished goods inventory, December 31 136,010 (d)
    Sales 1,132,620 1,029,700
    Cost of goods sold (d) 666,220
    Gross profit (e) (e)
    Operating expenses 147,530 (f)
    Net income (f) 228,590

    Required:

    1. Determine the amounts of the missing items, identifying them by letter. Enter all amounts as positive numbers.

    Letter On Company Off Company
    a. $fill in the blank 33b330f92fb1072_1 $fill in the blank 33b330f92fb1072_2
    b. $fill in the blank 33b330f92fb1072_3 $fill in the blank 33b330f92fb1072_4
    c. $fill in the blank 33b330f92fb1072_5 $fill in the blank 33b330f92fb1072_6
    d. $fill in the blank 33b330f92fb1072_7 $fill in the blank 33b330f92fb1072_8
    e. $fill in the blank 33b330f92fb1072_9 $fill in the blank 33b330f92fb1072_10
    f. $fill in the blank 33b330f92fb1072_11 $fill in the blank 33b330f92fb1072_12

    2. Prepare On Company's statement of cost of goods manufactured for December.

    On Company
    Statement of Cost of Goods Manufactured
    For the Month Ended December 31
    $fill in the blank e2405308c076f99_2
    Direct materials:
    $fill in the blank e2405308c076f99_4
    fill in the blank e2405308c076f99_6
    $fill in the blank e2405308c076f99_8
    fill in the blank e2405308c076f99_10
    $fill in the blank e2405308c076f99_12
    fill in the blank e2405308c076f99_14
    fill in the blank e2405308c076f99_16
    Total manufacturing costs incurred fill in the blank e2405308c076f99_17
    Total manufacturing costs $fill in the blank e2405308c076f99_18
    fill in the blank e2405308c076f99_20
    $fill in the blank e2405308c076f99_22

    3. Prepare On Company's income statement for December.

    On Company
    Income Statement
    For the Month Ended December 31
    $fill in the blank a97bcefff044f83_2
    Cost of goods sold:
    $fill in the blank a97bcefff044f83_4
    fill in the blank a97bcefff044f83_6
    $fill in the blank a97bcefff044f83_8
    fill in the blank a97bcefff044f83_10
    fill in the blank a97bcefff044f83_12
    $fill in the blank a97bcefff044f83_14
    fill in the blank a97bcefff044f83_16
    $fill in the blank a97bcefff044f83_18

In: Accounting

Scooters plans to sell a standard scooter for $ 120 and a chrome scooter for $...

Scooters plans to sell a standard scooter for $ 120 and a chrome scooter for $ 160. Steve's purchases the standard scooter for $ 30 and the chrome scooter for $ 40. Steve's expects to sell one standard scooter for every three chrome scooters. Steve's monthly fixed costs are $ 85,500.

1. How many of each type of scooter must Steve's Scooters sell each month to break​ even?

(Fixed costs + Target profit)/ Weighted-avg. CM per unit = Required sales in units

Standard Scooter formula: ______+_____/_____= required sales in units

Chrome Scooter formula: ______+_____/_____= required sales in units

Stevie's must sell ____ standard scooters and _____ Chrome scooters to break even.

2. How many of each type of scooter must Steve's Scooters sell each month to earn $ 67,500?

Standard Scooter formula: ______+_____/_____= required sales in units

Chrome Scooter formula: ______+_____/_____= required sales in units

Stevie's must sell ____ standard scooters and _____ Chrome scooters.

3. Suppose Steve's expectation to sell one standard scooter for every three chrome scooters was incorrect and for every four scooters sold two are standard scooters and two are chrome scooters. Will the breakeven point of total scooters increase or​ decrease? Why?​ (Calculation not​ required.)

Each standard scooter contributes $____ to profits while each chrome scooter contributes$_____ to profit.Therefore, the increase in sales of standard scooters and decrease in chrome scooters woud cause the weighted average contribution margin to _______ and the break even point to _______.

I am stuck at how to find the weighted-avg. CM per unit.

In: Accounting

Sequential Method Jasmine Company manufactures both pesticide and liquid fertilizer, with each product manufactured in separate...

Sequential Method

Jasmine Company manufactures both pesticide and liquid fertilizer, with each product manufactured in separate departments. Three support departments support the production departments: Power, General Factory, and Purchasing. Budgeted data on the five departments are as follows:


Support Departments
Producing Departments
Power General
Factory
Purchasing Pesticide Liquid
Fertilizer
Overhead $80,000 $314,000    $165,000    $78,800 $107,700
Square feet 1,500 —    1,500    4,200 4,800
Machine hours 1,403    1,345    24,000 8,000
Purchase orders 20    40    —    120 60

The company does not break overhead into fixed and variable components. The bases for allocation are power—machine hours; general factory—square feet; and purchasing—purchase orders.

The company has decided to use the sequential method of allocation instead of the direct method. The support departments are ranked in order of highest cost to lowest cost.

Required:

1. Allocate the overhead costs to the producing departments using the sequential method. Carry out allocation ratios to four decimal places. Use these numbers for subsequent calculations. Round allocated costs to the nearest dollar. If an amount is zero, enter "0".

Allocation ratios:

Power General Factory Purchasing Pesticide Liquid Fertilizer
Square feet
Machine hours
Purchase orders

Cost allocation:

Power General Factory Purchasing Pesticide Liquid Fertilizer
Direct costs $ $ $ $ $
General Factory               
Purchasing            
Power         
Total $ $ $ $ $

2. Using machine hours, compute departmental overhead rates. (Round the overhead rates to the nearest cent.)

Overhead Rates
Pesticide $ per machine hour
Liquid Fertilizer $ per machine hour

In: Accounting

Please answer the following questions: a) What is confidentiality and privacy controls in accounting information system?...

Please answer the following questions:

a) What is confidentiality and privacy controls in accounting information system?

b) How to identify and classify information that to be protected and how to protect confidentiality using encryption?

c) What is privacy regulations and generally accepted privacy principles?

In: Accounting

Service! Read through the discussion on service characteristics, service gaps and service recovery/failure in Chapter 13,...

Service! Read through the discussion on service characteristics, service gaps and service recovery/failure in Chapter 13, then answer the following questions: Which of the four characteristics differentiating services from product do you think leads to the most service failures and why? Please be sure to briefly explain the characteristic that you select. You’ve heard the saying “the customer is always right.” Do you think that’s true? Why or why not? Provide a specific situation you (as a customer) have faced a service failure: What were your expectations going into the service situation… and how did the service provider fail to meet your expectations? Was the service failure a result of service heterogeneity/variability or was it a result of the employee not being empowered to properly assist you – please explain.

In: Accounting

Building Your Skills Case [LO8-2, LO8-4, LO8-8, LO8-9, LO8-10] You have just been hired as a...

Building Your Skills Case [LO8-2, LO8-4, LO8-8, LO8-9, LO8-10] You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have worked with accounting and other areas to gather the information assembled below. The company sells many styles of earrings, but all are sold for the same price—$15 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings): January (actual) 21,000 June (budget) 51,000 February (actual) 27,000 July (budget) 31,000 March (actual) 41,000 August (budget) 29,000 April (budget) 66,000 September (budget) 26,000 May (budget) 101,000 The concentration of sales before and during May is due to Mother’s Day. Sufficient inventory should be on hand at the end of each month to supply 40% of the earrings sold in the following month. Suppliers are paid $4.50 for a pair of earrings. One-half of a month’s purchases is paid for in the month of purchase; the other half is paid for in the following month. All sales are on credit. Only 20% of a month’s sales are collected in the month of sale. An additional 70% is collected in the following month, and the remaining 10% is collected in the second month following sale. Bad debts have been negligible. Monthly operating expenses for the company are given below: Variable: Sales commissions 4 % of sales Fixed: Advertising $ 250,000 Rent $ 23,000 Salaries $ 116,000 Utilities $ 9,500 Insurance $ 3,500 Depreciation $ 19,000 Insurance is paid on an annual basis, in November of each year. The company plans to purchase $18,500 in new equipment during May and $45,000 in new equipment during June; both purchases will be for cash. The company declares dividends of $18,750 each quarter, payable in the first month of the following quarter. The company’s balance sheet as of March 31 is given below: Assets Cash $ 79,000 Accounts receivable ($40,500 February sales; $492,000 March sales) 532,500 Inventory 118,800 Prepaid insurance 23,500 Property and equipment (net) 1,000,000 Total assets $ 1,753,800 Liabilities and Stockholders’ Equity Accounts payable $ 105,000 Dividends payable 18,750 Common stock 900,000 Retained earnings 730,050 Total liabilities and stockholders’ equity $ 1,753,800 The company maintains a minimum cash balance of $55,000. All borrowing is done at the beginning of a month; any repayments are made at the end of a month. The company has an agreement with a bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. At the end of the quarter, the company would pay the bank all of the accumulated interest on the loan and as much of the loan as possible (in increments of $1,000), while still retaining at least $55,000 in cash. Required: Prepare a master budget for the three-month period ending June 30. Include the following detailed schedules: 1. a. A sales budget, by month and in total. b. A schedule of expected cash collections, by month and in total. c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total. d. A schedule of expected cash disbursements for merchandise purchases, by month and in total. 2. A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $55,000. 3. A budgeted income statement for the three-month period ending June 30. Use the contribution approach. 4. A budgeted balance sheet as of June 30

In: Accounting

Waving Through the Window You and your two roommates are starting a window washing service to...

Waving Through the Window

You and your two roommates are starting a window washing service to help put yourself through college. There are two other well-established window washing services in your area.

  • Should you set your price higher or lower than that of the competition? Justify your answer.

One roommate believes the most important objective in setting prices for the business is to generate a large profit, while keeping an eye on your competitors’ prices; the other roommate believes it is important to maximize sales and set prices according to what your customers expect to pay.

  • Who is right and why?
  • How do the number of competitors in the market in this situation affect YOUR pricing strategy?

In: Accounting

Here are comparative statement data for Wildhorse Company and Sandhill Company, two competitors. All balance sheet...

Here are comparative statement data for Wildhorse Company and Sandhill Company, two competitors. All balance sheet data are as of December 31, 2022, and December 31, 2021.

Wildhorse Company

Sandhill Company

2022

2021

2022

2021

Net sales

$1,892,000 $580,000

Cost of goods sold

1,075,000 298,000

Operating expenses

260,000 87,000

Interest expense

8,200 2,200

Income tax expense

65,300 29,000

Current assets

498,742 $477,987 127,504 $ 121,585

Plant assets (net)

806,004 765,000 213,784 192,492

Current liabilities

101,477 115,997 54,082 46,330

Long-term liabilities

174,405 137,700 45,319 38,250

Common stock, $10 par

765,000 765,000 183,600 183,600

Retained earnings

263,864 224,290 58,287 45,897


(a)

Prepare a vertical analysis of the 2022 income statement data for Wildhorse Company and Sandhill Company. (Round all ratios to 1 decimal place, e.g. 2.5%.)

Condensed Income Statement
For the Year Ended December 31, 2022

Wildhorse Company

Sandhill Company

Dollars

Percent

Dollars

Percent

select an income statement item                                                          Total ExpensesTotal Operating ExpensesDividendsCost of Goods SoldSales RevenuesIncome From OperationsNet SalesIncome Tax ExpenseOther Revenues and GainsOther Expenses and LossesExpensesOperating ExpensesGross ProfitInterest ExpenseRetained Earnings, December 31Retained Earnings, January 1Income Before Income TaxesNet Income / (Loss)Total Revenues

$1,892,000

enter percentages

%

$580,000

enter percentages

%

select an income statement item                                                          Total ExpensesTotal Operating ExpensesExpensesTotal RevenuesGross ProfitCost of Goods SoldNet Income / (Loss)Income Before Income TaxesSales RevenuesNet SalesInterest ExpenseOther Expenses and LossesIncome From OperationsOther Revenues and GainsRetained Earnings, December 31Operating ExpensesDividendsIncome Tax ExpenseRetained Earnings, January 1

1,075,000

enter percentages

%

298,000

enter percentages

%

select a summarizing line for the first part                                                          Cost of Goods SoldDividendsOther Revenues and GainsNet SalesTotal ExpensesSales RevenuesGross ProfitIncome Tax ExpenseRetained Earnings, December 31Operating ExpensesIncome Before Income TaxesIncome From OperationsExpensesNet Income / (Loss)Other Expenses and LossesTotal RevenuesInterest ExpenseRetained Earnings, January 1Total Operating Expenses

817,000

enter percentages

%

282,000

enter percentages

%

select an income statement item                                                          Net SalesIncome From OperationsCost of Goods SoldOther Expenses and LossesDividendsOther Revenues and GainsIncome Tax ExpenseExpensesTotal ExpensesNet Income / (Loss)Interest ExpenseTotal Operating ExpensesIncome Before Income TaxesRetained Earnings, January 1Retained Earnings, December 31Total RevenuesGross ProfitSales RevenuesOperating Expenses

260,000

enter percentages

%

87,000

enter percentages

%

select a summarizing line for the second part                                                          Income Tax ExpenseCost of Goods SoldNet Income / (Loss)Income From OperationsNet SalesTotal Operating ExpensesGross ProfitIncome Before Income TaxesDividendsOther Expenses and LossesTotal RevenuesInterest ExpenseTotal ExpensesExpensesOperating ExpensesSales RevenuesOther Revenues and GainsRetained Earnings, January 1Retained Earnings, December 31

557,000

enter percentages

%

195,000

enter percentages

%

select an opening section name                                                          Operating ExpensesSales RevenuesTotal ExpensesGross ProfitIncome Before Income TaxesCost of Goods SoldExpensesRetained Earnings, December 31Net Income / (Loss)Income From OperationsRetained Earnings, January 1Other Expenses and LossesIncome Tax ExpenseTotal Operating ExpensesNet SalesTotal RevenuesDividendsOther Revenues and GainsInterest Expense

select an income statement item                                                          Interest ExpenseNet SalesGross ProfitTotal Operating ExpensesRetained Earnings, January 1Other Revenues and GainsExpensesIncome Tax ExpenseIncome From OperationsRetained Earnings, December 31Total ExpensesSales RevenuesOperating ExpensesNet Income / (Loss)Total RevenuesCost of Goods SoldIncome Before Income TaxesOther Expenses and LossesDividends

8,200

enter percentages

%

2,200

enter percentages

%

select a summarizing line for the third part                                                          Other Revenues and GainsGross ProfitExpensesIncome Tax ExpenseRetained Earnings, January 1Total RevenuesRetained Earnings, December 31Total Operating ExpensesIncome Before Income TaxesIncome From OperationsDividendsSales RevenuesNet Income / (Loss)Net SalesInterest ExpenseCost of Goods SoldOther Expenses and LossesTotal ExpensesOperating Expenses

548,800

enter percentages

%

192,800

enter percentages

%

select an income statement item                                                          Interest ExpenseExpensesTotal RevenuesGross ProfitTotal ExpensesNet SalesCost of Goods SoldRetained Earnings, January 1Total Operating ExpensesIncome From OperationsRetained Earnings, December 31Net Income / (Loss)DividendsOperating ExpensesSales RevenuesIncome Before Income TaxesOther Revenues and GainsIncome Tax ExpenseOther Expenses and Losses

65,300

enter percentages

%

29,000

enter percentages

%

select a closing name for this statement                                                          ExpensesIncome From OperationsNet SalesOperating ExpensesNet Income / (Loss)Total ExpensesIncome Tax ExpenseCost of Goods SoldOther Expenses and LossesRetained Earnings, January 1Interest ExpenseTotal RevenuesIncome Before Income TaxesOther Revenues and GainsTotal Operating ExpensesSales RevenuesDividendsRetained Earnings, December 31Gross Profit

$483,500

enter percentages

%

$163,800

enter percentages

%


(b1)

Compute the 2022 return on assets and the return on common stockholders’ equity for both companies. (Round all ratios to 1 decimal place, e.g. 2.5%.)

Wildhorse Company

Sandhill Company

Return on assets

enter percentages

%

enter percentages

%

Return on common stockholders’ equity

enter percentages

%

enter percentages

%

In: Accounting

Use 3 paragraphs: Briefly describe and distinguish the 'planning' and 'control' aspects of management accounting. Give...

Use 3 paragraphs: Briefly describe and distinguish the 'planning' and 'control' aspects of management accounting. Give examples of how management accounting information is used for both planning and control purposes in your organization.

In: Accounting

You set up your own business in merchandising sector. You lease a space of 6,000 square...

You set up your own business in merchandising sector. You lease a space of 6,000 square feet to open a luxury watch shop.

The following is minimum information regarding the business:

- Specific sub-sector: Merchandising sector.

-   Business model: buying and selling luxury watches.

-   Investment by owner: $1,000,000

- You hire a shop manager, two accounting staffs who also keep the merchandise, one security officer, and 8 full-time sales assistants.

-   Business costs/expenses should have at least the following: cost of merchandise sold, rent expense, salary, utilities expense, advertising expense, interest expense, and miscellaneous expenses.

-Capital structure: must have both Investment by owner ($1,000,000) and Bank loan.

Set up an effective Internal Control System for the business using 5 different internal control elements.

In: Accounting

Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital...

Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: Activity Activity Rate Room and meals $237 per day Radiology $334 per image Pharmacy $53 per physician order Chemistry lab $90 per test Operating room $740 per operating room hour The activity usage information associated with the two patients is as follows: Abel Putin Cheryl Umit Number of days 3 days 11 days Number of images 4 images 5 images Number of physician orders 6 orders 8 orders Number of tests 3 tests 6 tests Number of operating room hours 4 hours 7 hours a. Determine the activity cost associated with each patient.

In: Accounting

Single Plantwide and Multiple Production Department Factory Overhead Rate Methods and Product Cost Distortion Pineapple Motor...

Single Plantwide and Multiple Production Department Factory Overhead Rate Methods and Product Cost Distortion Pineapple Motor Company manufactures two types of specialty electric motors, a commercial motor and a residential motor, through two production departments, Assembly and Testing. Presently, the company uses a single plantwide factory overhead rate for allocating factory overhead to the two products. However, management is considering using the multiple production department factory overhead rate method. The following factory overhead was budgeted for Pineapple: Assembly Department $220,000 Testing Department 809,600 Total $1,029,600 Direct machine hours were estimated as follows: Assembly Department 4,400 hours Testing Department 8,800 Total 13,200 hours In addition, the direct machine hours (dmh) used to produce a unit of each product in each department were determined from engineering records, as follows: Commercial Residential Assembly Department 0.50 dmh 1.00 dmh Testing Department 1.00 2.00 Total machine hours per unit 1.50 dmh 3.00 dmh a. Determine the per-unit factory overhead allocated to the Commercial and Residential motors under the single plantwide factory overhead rate method, using direct machine hours as the allocation base. Commercial Motor $ per unit Residential Motor $ per unit b. Determine the per-unit factory overhead allocated to the Commercial and Residential motors under the multiple production department factory overhead rate method, using direct machine hours as the allocation base for each department. Commercial Motor $ per unit Residential Motor $ per unit

In: Accounting

You have just been hired as a new management trainee by Earrings Unlimited, a distributor of...

You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have worked with accounting and other areas to gather the information assembled below.

The company sells many styles of earrings, but all are sold for the same price—$16 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings):

January (actual) 23,400 June (budget) 53,400
February (actual) 29,400 July (budget) 33,400
March (actual) 43,400 August (budget) 31,400
April (budget) 68,400 September (budget) 28,400
May (budget) 103,400

The concentration of sales before and during May is due to Mother’s Day. Sufficient inventory should be on hand at the end of each month to supply 40% of the earrings sold in the following month.

Suppliers are paid $5.70 for a pair of earrings. One-half of a month’s purchases is paid for in the month of purchase; the other half is paid for in the following month. All sales are on credit. Only 20% of a month’s sales are collected in the month of sale. An additional 70% is collected in the following month, and the remaining 10% is collected in the second month following sale. Bad debts have been negligible.

Monthly operating expenses for the company are given below:

Variable:
Sales commissions 4 % of sales
Fixed:
Advertising $ 370,000
Rent $ 35,000
Salaries $ 140,000
Utilities $ 15,500
Insurance $ 4,700
Depreciation $ 31,000

Insurance is paid on an annual basis, in November of each year.

The company plans to purchase $24,500 in new equipment during May and $57,000 in new equipment during June; both purchases will be for cash. The company declares dividends of $27,750 each quarter, payable in the first month of the following quarter.

The company’s balance sheet as of March 31 is given below:

Assets
Cash $ 91,000
Accounts receivable ($47,040 February sales; $555,520 March sales) 602,560
Inventory 155,952
Prepaid insurance 29,500
Property and equipment (net) 1,120,000
Total assets $ 1,999,012
Liabilities and Stockholders’ Equity
Accounts payable $ 117,000
Dividends payable 27,750
Common stock 1,140,000
Retained earnings 714,262
Total liabilities and stockholders’ equity $ 1,999,012

The company maintains a minimum cash balance of $67,000. All borrowing is done at the beginning of a month; any repayments are made at the end of a month.

The company has an agreement with a bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. At the end of the quarter, the company would pay the bank all of the accumulated interest on the loan and as much of the loan as possible (in increments of $1,000), while still retaining at least $67,000 in cash.

Required:

Prepare a master budget for the three-month period ending June 30. Include the following detailed schedules:

1. a. A sales budget, by month and in total.

    b. A schedule of expected cash collections, by month and in total.

    c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total.

    d. A schedule of expected cash disbursements for merchandise purchases, by month and in total.

2. A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $67,000.

3. A budgeted income statement for the three-month period ending June 30. Use the contribution approach.

4. A budgeted balance sheet as of June 30.

In: Accounting