Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Accounting Basics Expert

Perfect Gas Corporation supplies compressed gases to industry customers. Data regarding the store's operations follow:

• Sales are budgeted at $345,000 for November, $230,000 for December, and $320,000 for January.

• Collections are expected to be 60% in the month of sale, 34% in the month following the sale, and 6% uncollectible.

• The cost of goods sold is 70% of sales.

• The company desires ending merchandise inventory to equal 80% of the following month's cost of goods sold. Payment for merchandise is made in the month following the purchase.

• Other monthly expenses to be paid in cash are $12,000.

• Monthly depreciation is $16,000.

• Equipment purchases of $110,000 were paid in cash in November.

• Dividends of $35,000 were declared and paid in December.

• Any borrowings must be in $1,000 increments at 7% interest. Assume interest accrues at the beginning of the month and is paid at the end of the month. The company must maintain a minimum cash balance of $5,000.

• Ignore income taxes.

Prepare the following budgets for November and December and total for the two months in good form in excel and submit via bblearn by 5/9 at noon:

a. Prepare a Schedule of Expected Cash Collections

b. Prepare a Merchandise Purchases Budget

c. Prepare Cash Budgets

d. Prepare Budgeted Income Statements

e. Prepare a Budgeted Balance Sheet

Prepare a letter/memo to the company's CEO with specific recommendations regarding your budget.

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M945752

Have any Question? 


Related Questions in Accounting Basics

Problem -a firm has the following probability distribution

Problem - A firm has the following probability distribution for annual losses due to vandalism. All amounts are before any tax consideration. The firm has a tax rate of 20%. Annual Losses Probability $ 0 .75 $ 4,000 .20 ...

Question 1how would outstanding checks be handled when

Question 1 How would outstanding checks be handled when reconciling the ending cash balance per the bank statement to the correct adjusted cash balance? A. They would be added to the balance of the bank statement. B. The ...

Accountingimagine that you are a consultant working on a

Accounting Imagine that you are a consultant working on a special project to help a company determine techniques that it can use in order to calculate the fair value of investments. From the e-activity, prepare a report ...

Mnc paper and presentationgoogle company paper and

MNC Paper and Presentation: GOOGLE COMPANY Paper and Presentation will consist of research to write a paper on an annual SEC 10-K report filed by a public multinational corporation with the U.S. Securities and Exchange C ...

Problem 1 mat Problem 1 Mat. Date Rate(%) 1/15/2017 0.5 4/15/2017 0.6 7/15/2017 0.75

Problem 1 Mat. Date Rate(%) 1/15/2017 0.5 4/15/2017 0.6 7/15/2017 0.75 10/15/2017 1.0 1/15/2018 1.25 4/15/2018 1.5 7/15/2018 1.75 10/15/2018 2.0 1/15/2019 2.1 4/15/2019 2.2 7/15/2019 2.3 10/15/2019 2.4 Table 1: Continuou ...

Your city has decided to build a new library the projected

Your city has decided to build a new library. The projected cost is $2 million. A bond issue for $1.2 million has been authorized, and the remainder is supposed to come from a contribution of $800,000 from the general fu ...

Assignmentpigskin must decides how many footballs to

Assignment Pigskin must decides how many footballs to produce each month for 6-month planning horizon. Monthly demand must be satified on time. Set a model to determine the production plan for next 6 months which incurs ...

1 a psychologist studied the number of puzzles subjects

1. A psychologist studied the number of puzzles subjects were able to solve in a five minute period while listening to soothing music. Let X be the number of puzzles completed successfully by a subject. X had the followi ...

Accounting and regulatory environmenti need someone to

Accounting and Regulatory Environment. I need someone to write a paper for me on accounting and the regulatory environment. The instructions are below on what it is to include. In the wake of the accounting and finance s ...

1 a b and c are the members of all llc a limited liability

1. A, B and C are the members of All, LLC, a limited liability company that is treated as a partnership for federal income tax purposes. All, LLC is contemplating taking a loan of $90,000 from a local Maryland bank to fi ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro