Search This Blog

Kwik Delivery Service reports the following costs and expenses in June 2016.

Click here for tutorial

Question 1
The following information is available for Mergenthaler Corporation for the year ended December 31, 2017:

         Collection of principal on long-term loan to a supplier                                               $16,000
         Acquisition of equipment for cash                                                                               10,000
         Proceeds from the sale of long-term investment at book value                                 22,000
         Issuance of common stock for cash                                                                           20,000
         Depreciation expense                                                                                                  25,000
         Redemption of bonds payable at carrying (book) value                                             34,000
         Payment of cash dividends                                                                                           6,000
         Net income                                                                                                                  30,000
         Purchase of land by issuing bonds payable                                                                40,000

In addition, the following information is available from the comparative balance sheet for Mergenthaler at the end of 2017 and 2016:
                                                                                                 2017                        2016  
         Cash                                                                            $148,000                 $91,000
         Accounts receivable (net)                                               25,000                   15,000
         Prepaid insurance                                                           19,000                   13,000
         Total current assets                                                    $192,000               $119,000

         Accounts payable                                                       $  30,000                 $19,000
         Salaries and wages payable                                             6,000                     7,000
         Total current liabilities                                                 $  36,000                 $26,000

Instructions
Prepare Mergenthaler's statement of cash flows for the year ended December 31, 2017, using the indirect method.


Question 2
Here is financial information for Valdez Express Inc.

                                                            December 31, 2017                December 31, 2016
Current assets                                              $114,000                                   $80,000
Plant assets (net)                                           414,000                                   360,000
Current liabilities                                               91,000                                     65,000
Long-term liabilities                                        134,500                                     90,000
Common stock, $1 par                                  149,500                                   115,000
Retained earnings                                          153,000                                   170,000

Instructions
Prepare a schedule showing a horizontal analysis for 2017 using 2016 as the base year.

Question 3
Kwik Delivery Service reports the following costs and expenses in June 2016.

Indirect materials                            $  8,400            Driver's salaries                                 $17,000
Depreciation on delivery                                          Advertising                                             5,100
equipment                                   11,200            Delivery equipment                                        
Dispatcher's salary                             5,000                    repairs                                                300
Property taxes on office                                          Office supplies                                          650
building                                             870            Office utilities                                         2,490
CEO's salary                                     12,000            Repairs on office                                           
Gas and oil for delivery trucks            3,200                    equipment                                          180

Instructions
Determine the total amount of (a) delivery service (product) costs and (b) period costs.

Question 4
Erickson, Inc. makes student book bags that sell for $20 each. For the coming year, management expects fixed costs to be $225,000. Variable costs are $14 per unit.

Instructions
(a)   Compute break-even sales in dollars using the mathematical equation.
(b)   Compute break-even sales using the contribution margin ratio.
(c)   Compute margin of safety ratio assuming actual sales are $937,500.

(d)   Compute the sales required to earn net income of $150,000, using the mathematical equation.

Click here for tutorial

You have just been contracted as a budget consultant by LBJ Company, a distributor of bracelets to various

Click here for tutorial

You have just been contracted as a budget consultant by LBJ Company, a distributor of bracelets to various retail outlets across the country. The company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash.

You have decided to prepare a cash budget for the upcoming fourth quarter in order to show management the benefits that can be gained from proper cash planning.  You have worked with accounting and other areas to gather the information assembled below.

The company sells many styles of bracelets, but all are sold for the same $10 price.  Actual sales of bracelets for the last three months and budgeted sales for the next six months follow:

July (actual)20,000
August (actual)26,000
September (actual)  40,000        
October (budget)      70,000
November (budget)   110,000
December (budget)   60,000
January (budget)       30,000
February (budget)      28,000
March (budget)             25,000

The concentration of sales in the fourth quarter is due to the Christmas holiday. Sufficient inventory should be on hand at           ....................................... AND SO ON ....................................................





REQUIRED:

1.  Prepare a cash budget for the three-month period ending December 31. Include the following detailed budgets:
     a. A sales budget, by month and in total.
     b. A schedule of expected cash collections from sales, 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 $50,000.

Click here for tutorial

Music-Is-Us, Inc., is a supplier of musical instruments for professional and amateur

Click here for tutorial

COMPREHENSIVE PROBLEM 2
Music-Is-Us, Inc.
Music-Is-Us, Inc., is a supplier of musical instruments for professional and amateur musicians. The company's accountants make adjusting entries monthly, and they make all closing entries annually. The company is growing rapidly and prides itself on having no long-term liabilities.

The company has provided the following trial balance dated December 31, 2015:


Other information pertaining to the company's trial balance is shown below: 


  1. The most recent bank statement reports a balance of $46,975. Included with the bank statement was a $2,500 check from Iggy Smarts, a professional musician, charged back to Music-Is-Us as NSF. The bank's monthly service charge was $25. Three checks written by Music-Is-Us to suppliers of merchandise inventory had not yet cleared the bank for payment as of the statement date. These checks included: no. 508, $5,500; no. 511, $7,500; and no. 521, $8,000. Deposits of $16,500 reached the bank too late for inclusion in the current bank statement. The company prepares a bank reconciliation at the end of each month.
All tabs completed till ratio cash conversion cycle in the provided template

Click here for tutorial

Given financial information, prepare Coopie Awards' master budget. Notice, you will prepare a different budget

Click here for tutorial

Accounting 141 Budgeting for a Manufacturer - coopie awards

Given financial information, prepare Coopie Awards' master budget. Notice, you will prepare a different budget on each tab of the spreadsheet. The last tab in the spreadsheet you will complete for the discussion forum.

Coopie Awards produces brass plaques. They operates in 3 regions of the country. The western region sales manager estimates sales of 20,000 plaques for the region. The central regional manager estimates sales of 10,000 plaques for the region and the eastern sales manager estimates slaes of 15,000 plaques for the region. Each plaque sells for $35.

Requirement: Prepare the sales budget for Coopie Awards
production budget
Direct materials budget
Direct labor cost budget
cost of goods sold budget
selling and admin expense budget
income statement
actual results
Coopie Awards sold 43,000 brass plaques for the current year with the following results. In the discussion forum comment on Coopie Awards results.

Click here for tutorial

Compute the future value in year 9 of a $2,000 deposit in year 1 and another

Click here for tutorial

Complete the following problem sets from Chapter 5 in Microsoft® Excel®:
   5-1
   5-3
   5-5
   5-7
   5-12
   5-15
5-39 (Calculate monthly payment only)


5-1   FutureValue Compute the future value in year 9 of a $2,000 deposit in year 1 and another $1,500 deposit at the end of year 3 using a 10 percent interest rate. (LG5-1)

5-3   Future Value of an Annuity What is the future value of a $900 annuity payment over five years if interest rates are 8 percent? (LG5-2)

5-5   Present Value Compute the present value of a $2,000 deposit in year 1 and another $1,500 deposit at the end of year 3 if interest rates are 10 percent. (LG5-3)

5-7   Present Value of an Annuity What’s the present value of a $900 annuity payment over five years if interest rates are 8 percent? (LG5-4)

5-12   Present Value of an Annuity Due If the present value of an ordinary, 6-year annuity is $8,500 and interest rates are 9.5 percent, what’s the present value of the same annuity due? (LG5-6)

5-15   Effective Annual Rate A loan is offered with monthly payments and a 10 percent APR. What’s the loan’s effective annual rate (EAR)? (LG5-7)


5-39   Loan Payments You wish to buy a $25,000 car. The dealer offers you a 4-year loan with a 9 percent APR. What are the monthly payments? How would the payment differ if you paid interest only? What would the consequences of such a decision be? 

Click here for tutorial