Monthly selling and administrative expenses are budgeted as

Assignment Help Accounting Basics
Reference no: EM13579728

Nordic Company, a merchandising company, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the second quarter.

a.

As of March 31 , the company%u2019s balance sheet showed the following account balances:






  Cash $ 15,000     

  Accounts receivable
59,200     

  Inventory
16,920     

  Buildings and equipment (net)
234,000     

  Accounts payable

$ 24,000    
  Capital stock


170,000    
  Retained earnings


131,120    




$ 325,120      $ 325,120    






b. Actual sales for March and budgeted sales for April%u2013July are as follows:


  March (actual) $74,000
  April $94,000
  May $104,000
  June $109,000
  July $64,000

c.

Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following the sale. The accounts receivable at March 31 are a result of March credit sales.

d. The company%u2019s gross margin percentage is 40% of sales.
e.

Monthly selling and administrative expenses are budgeted as follows: salaries and wages, $12,000 per month; shipping, 6% of sales; advertising, $7,400 per month; other expenses, 4% of sales. Depreciation, including depreciation on new assets acquired during the quarter, will be $6,000 for the quarter.

f. Each month%u2019s ending inventory should equal 30% of the following month%u2019s cost of goods sold.
g.

Half of a month%u2019s inventory purchases are paid for in the month of purchase and half in the following month.

h.

Equipment purchases during the quarter will be as follows: April, $12,000; and May, $5,000.

i. Dividends totaling $3,500 will be declared and paid in June.
j.

Management wants to maintain a minimum cash balance of $8,000. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $20,000. The interest rate on these loans is 1% per month, and for simplicity, we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.

Required:
Using the data above, complete the following statements and schedules for the second quarter:
Schedule of expected cash collections:

Reference no: EM13579728

Questions Cloud

Timberly construction negotiates a lump-sum purchase of : timberly construction negotiates a lump-sum purchase of several assets from a company that is going out of business.
Is there sufficient evidence to support the claim that : data from six students relating number of hours of preperation x and test score y yield a linear correlation
Assume that the land is sold on 1113 and that sanoma : padilla company purchased 80 of the common stock of sanoma company in the open marke on january 1 2010 paying 31000
The value of the linear correlation coefficient was found : using data collected from the fbi the number of registered automatic weapons and the murder rate were obtained for
Monthly selling and administrative expenses are budgeted as : nordic company a merchandising company prepares its master budget on a quarterly basis. the following data have been
Product a has a sales price of 10 per unit based on a : 1 jamesway corporation has two seperate divisions that operate as profit centers. the following information is
A committee of 3 people is formed from 6 women and 4 men : a committee of 3 people is formed from 6 women and 4 men. what is the cumulative probability function for the number of
Ue the data and stepwise regression to predict the cost : question the u.s. energy information administration releases figures in their publication monthly energy review about
If 2000 units remain unsold at the end of the month and : a business operated at 100 of capacity during its first month and incurred the following costs production costs 10000

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd