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

Principles of accountingthe accounting cyclequestion

Principles of Accounting The Accounting Cycle Question A • Explain why temporary accounts are closed each period. Question B • Identify the 10 steps in the accounting cycle.

1 regarding the ottoman territories during the period

1. Regarding the Ottoman territories during the period immediately following World War I, which of the following statements is false? A. Defying Allied pressure, the Turkish sultan supported Kemal. B. In 1921, Greek forc ...

Case title the website launchyour company meddevice inc has

Case Title: The Website Launch Your Company, MedDevice, Inc., has just received FDA 510(k) clearance of its new, cutting edge medical device which paves the way for the official product launch in a few short months. Your ...

Article critiqueuse the csu online library to locate and

Article Critique Use the CSU Online Library to locate and review a scholarly article found in a peer reviewed journal related to: Unions, Labor Relations, or International Human Resources Management. There is a minimum r ...

Question 1the accounts receivable account has total debit

Question 1 The Accounts Receivable account has total debit postings of $1,900 and credit postings of $1,100. The balance of the account is a/an A. $800 debit. B. $800 credit. C. $2,600 credit. D. $2,600 debit. Question 2 ...

Write think about a specificissue or policy that you are

Write: Think about a specificissue or policy that you are interested in and/or that has impacted you personally. Use the assigned resources that are provided for this journal to gather information about the goals and pro ...

Tf question1under the modified accrual basis of accounting

T/F QUESTION 1 Under the modified accrual basis of accounting, there is no matching principle and no attempt to amortize costs that benefit multiple periods. 2 In fund accounting, expenditures may be classified in differ ...

Question 1the following transactions occurred during july o

Question 1 The following transactions occurred during July: o Received $900 cash for services provided to a customer during July. o Received $2,200 cash investment from Barbara Hanson, the owner of the business. o Receiv ...

Westerville company reported the following results from

Westerville Company reported the following results from last year % 2013 operations: Sales $ 1,000,000 Variable expenses 300,000 -------------------------------------- Contribution margin 700,000 Fixed expenses 500,000 - ...

Question 1under the allowance method bad debt expense is

Question 1 Under the allowance method, Bad Debt Expense is recorded A. as an estimate. B. when an individual account is written off. C. several times during the year as needed. D. None of the above Question 2 Which amoun ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen