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

1 mrs beach wants to invest a lump sum of money today to

1. Mrs. Beach wants to invest a lump sum of money today to have $100,000 when she retires at 65 (she is 40 today). a. How much of a deposit would she have to make if the interest rate on the C.D. was 5%? b. What would Mr ...

The company uses a periodic inventory system for specific

The Company uses a periodic inventory system. For specific identification, ending inventory consists of 375 units, where 190 are from the January 30 purchase, 80 are from the January 20 purchase, and 105 are from beginni ...

Discussionpart 1 please respond the following question no

Discussion Part 1 please respond the following question no less then 350 words (original work, no plagiarism, 1 reference "fairness of the federal estate tax and income and principal in fiduciary accounting" please respo ...

Assignment comparing capital expenditurescomparing capital

Assignment: Comparing Capital Expenditures Comparing Capital Expenditures Select a company and access the last three years' annual reports. Next, select a company that is a direct competitor and download the previous thr ...

Kiona co set up a petty cash fund for payments of small

Kiona Co. set up a petty cash fund for payments of small amounts. The following transactions involving the petty cash fund occurred in May (the last month of the company's fiscal year). May 1 Prepared a company check for ...

Module 1 1 page topic selectionselect any topic in

Module 1 ( 1 Page ) Topic Selection Select any topic in accounting of interest that connects to the subject matter of this course. If you have already selected the area of your doctoral research, you may choose a topic i ...

Assignment reorganizationtarget corporation holds assets

Assignment: Reorganization Target Corporation holds assets with a fair market value of $4 million (adjusted basis of $2.2 million) and liabilities of $1.5 million. It transfers assets worth $3.7 million to Acquiring Corp ...

Intercompany debt both long term and short term arises

Intercompany debt, both long term and short term, arises frequently. In some cases, intercorporate borrowings may arise because one affiliate can borrow at a cheaper rate than others, and lending to other affiliates may ...

Kent cpa is a staff auditor participating in the audit

Kent, CPA is a staff auditor participating in the audit engagement of Fort, Inc. Based upon each of the circumstances below, indicate whether or not Kent's actions impair his independence. Explain your response for each ...

Assessment cloud on-line accounting and systems

Assessment: Cloud On-line Accounting and Systems Documentation You are working as an accountant in an accounting firm. You have been approached by the owner of "Splash!" a start-up business that sells swimming accessorie ...

  • 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