AM is a trading entity. Purchases are on credit, with 70% paid in the month following the date of
purchase and 30% paid in the month after that.
Sales are partly on credit and partly for cash. Customers who receive credit are given 30 days to
pay. On average 60% pay within30 days, 30% pay between 30 and 60 days and 5% pay between
60 and 90 days. The balance is written off as irrecoverable. Other
are paid within the month incurred.
AM plan to purchase new equipment at the end of June 2015, the expected cost of which is
P250,000. The equipment will be purchases on 30 days credit, payable at the end of July.
The cash balance on 1 May 2015 is P96,000.
The actual/budgeted figures for the six month to July 2015 were:
ACTUAL | BUDGETED | |||||
FEB P000 | MARCH P000 | APRIL P000 | MAY P000 | JUNE P000 | JULY P000 | |
Credit sales | 100 | 100 | 110 | 110 | 120 | 120 |
Cash sales | 30 | 30 | 35 | 35 | 40 | 40 |
Credit Purchases | 45 | 50 | 50 | 55 | 55 | 60 |
other overhead expenses | 40 | 40 | 40 | 50 | 50 | 50 |
Required:
a. Prepare a monthly
b. Assess the likelihood of AM being able to pay for the equipment when it falls due.
Step by stepSolved in 3 steps
- Question Hare, Inc., had a cost of goods sold of $43,921. At the end of the year, the accounts payable balance was $7,943. How long on average did it take the company to pay off its suppliers during the year? (Use 365 days a year. Do not round intermediate calculations and round your final answer to 2 decimal places, e.g., 32.16.)arrow_forwardA company began operations in March with cash and common stock of $36,000. The company made $582,000 in net income in its first month. It performed print jobs for customers and billed these customers $900,000. The company collected half of its receivables by the end of the month. The company had a cost of goods sold of $162,000 paid for in cash and $6,000 inventory left over at the end of the month. The company's employees earned wages but those are not paid until the first of April. This was the company’s only liability. How would I calculate the income statement and balance sheet for the end of March?arrow_forwardMorrison Company Balance Sheet January 1 Assets Cash $ 40,950 Raw materials Work in process Finished goods Prepaid expenses Property, plant, and equipment (net) $ 17,800 6,600 31,800 56, 200 3,350 124,000 $ 224,500 Total assets Liabilities and Stockholders' Equity Accounts payable Retained earnings $ 7,100 217,400 Total liabilities and stockholders' equity $ 224,500 During January the company completed the following transactions: a. Purchased raw materials on account, $75,200. b. Raw materials used in production, $91,500 ($80,200 was direct materials and $11,300 was indirect materials). c. Paid $202.100 of salaries and wages in cash ($108,800 was direct labor, $41,700 was indirect labor, and $51,600 was related to employees responsible for selling and administration). d. Various manufacturing overhead costs incurred (on account) to support production, $43,350. e. Depreciation recorded on property, plant, and equipment, $63,600 (70% related to manufacturing equipment and 30% related to…arrow_forward
- Using the following information. a. Beginning cash balance on March 1, $81,000. b. Cash receipts from sales, $305.000. c. Cash payments for direct materials, $130.000. d. Cash payments for direct labor. $79,000. e. Cash payments for overhead, $38.00. f. Cash payments for sales commissions, $7000 g. Cash payments for interest, $130 (1% of beginning loan balance of $13,000) h. Cash repayment of loan, $13.000. Prepare a cash budget for March for Gado Company. GADO COMPANY Cash Budget March Total cash available Less: Cash payments for Total cash payments $4 Loan activity Loan balance, end of month %24 K Prev earcharrow_forwardCS&N Enterprises expects to sell 50,000 units in January and produce 55,000 units. The selling price per unit is $40. All sales are on credit. Customer amounts on account are collected 70% in the month of sale and 25% in the month following and 5% are never collected. Estimated Variable S&A are expected to be $3 per unit sold plus bad debt. Fixed S&A are estimated to be $30,000 of which $4,000 of the $30,000 is depreciation. What is the total budgeted selling and administrative expense?arrow_forwardSelling, general, and administrative costs totaled $20 million, all on a short-term credit basis with vendors. We paid $19 million (cash) in outstanding accounts payable during the quarter. What are the journal entries?arrow_forward
- 16. At the end of the year, a company finds that it has under-applied factory overhead by $1,000. What would be the most common accounting treatment in this case? Increase Assets by $1,000 on the Balance Sheet Increase Profit by $1,000 in the Income Statement Increase Liabilities by $1,000 on the Balance Sheet Decrease Cost of Goods Sold by $1,000 in the Income Statement Increase Cost of Goods Sold by $1,000 in the Income Statement.arrow_forwardAidel Inc., a merchandising company, reported the following results for September. Cost of goods sold 205,837 Fixed selling and administrative expense 41,331 Variable selling and administrative expense, 86,269 Sales revenue 563,800 This question is independent of all other questions. Please use only the information in this question to calculate the answer. Based on the information provided above, calculate break – even in dollars. Cost of goods sold is a variable cost in this company. Enter only the amount for the break – even in dollars in the box provided below ( rounded to a whole number, based on general rounding rules). Enter the amount only. Do not enter letters, words, dollar signs or the calculation.arrow_forwardColleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Number of orders Units per order Sales returns: Number of returns Total units returned Number of sales calls Jerry, Incorporated Kate Company 6 30 1,000 420 4 5 50 13 140 5 Colleen sells its products at $290 per unit. The firm's gross margin ratio is 20%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30 months, the firm has determined the following activity costs: Activity Sales calls Cost Driver and Rate $800 per visit Order processing Deliveries Sales returns Sales salary Required: 180 per order 410 per order 270 per return and $3 per unit returned 107,000 per month 1. Using customers as the cost objects, classify the activity costs into cost categories (unit-level, batch-level, etc.) and compute the total cost for Colleen Company…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education