On July 1, MTC Wholesalers had a cash balance of $315,000 and accounts payable (related to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
On July 1, MTC Wholesalers had a cash balance of $315,000 and accounts payable (related to inventory purchases) of $178,200. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual Sales Month May June $270,000 July 288,000 August Budgeted Sales $ 162,000 144,000 September October 180,000 216,000 All sales are on credit with 75 percent collected during the month of sale, 20 percent collected during the next month, and 5 percent collected during the second month following the month of sale. Cost of goods sold averages 70 percent of sales revenue. Ending inventory is one-half of the next month's predicted cost of sales. The other half of the merchandise is acquired during the month of sale. All purchases are paid for in the month after purchase. Operating costs are estimated at $50,400 each month and are paid during the month incurred. Required Prepare purchases and cash budgets for July, August, and September. Do not use a negative sign with your answers. MTC Wholesalers Purchases Budget For the Months of July, August, and September July August September Inventory required, current sales $ $ $ Desired ending inventory Total inventory needs Less beginning inventory Purchases $ $ Do not use a negative sign with your answers. MTC Wholesalers Cash Budget For the Months of July, August, and September July August Cash balance, beginning $ 315000 $ Cash receipts Current month's sales Previous month's sales Sales two months prior Total receipts Cash available Cash disbursements: Purchases Operating costs Total disbursements Cash balance, ending $ $ $ September On July 1, MTC Wholesalers had a cash balance of $315,000 and accounts payable (related to inventory purchases) of $178,200. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual Sales Month May June $270,000 July 288,000 August Budgeted Sales $ 162,000 144,000 September October 180,000 216,000 All sales are on credit with 75 percent collected during the month of sale, 20 percent collected during the next month, and 5 percent collected during the second month following the month of sale. Cost of goods sold averages 70 percent of sales revenue. Ending inventory is one-half of the next month's predicted cost of sales. The other half of the merchandise is acquired during the month of sale. All purchases are paid for in the month after purchase. Operating costs are estimated at $50,400 each month and are paid during the month incurred. Required Prepare purchases and cash budgets for July, August, and September. Do not use a negative sign with your answers. MTC Wholesalers Purchases Budget For the Months of July, August, and September July August September Inventory required, current sales $ $ $ Desired ending inventory Total inventory needs Less beginning inventory Purchases $ $ Do not use a negative sign with your answers. MTC Wholesalers Cash Budget For the Months of July, August, and September July August Cash balance, beginning $ 315000 $ Cash receipts Current month's sales Previous month's sales Sales two months prior Total receipts Cash available Cash disbursements: Purchases Operating costs Total disbursements Cash balance, ending $ $ $ September
Expert Answer:
Answer rating: 100% (QA)
MTC Wholesalers Purchases Budget For the Months of July August and September Inventory required curr... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0078111006
14th edition
Authors: Ray Garrison, Eric Noreen and Peter Brewer
Posted Date:
Students also viewed these accounting questions
-
On July 1, MTC Wholesalers had a cash balance of $262,500 and accounts payable (related to inventory purchases) of $148,500. Actual sales for May and June, and budgeted sales for July, August,...
-
On July 1, MTC Wholesalers had a cash balance of $175,000 and accounts payable of $99,000. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual...
-
Posting the entries from the sales journal to the accounts receivable subsidiary ledger should be done ______. a). at the end of each month b). on a weekly basis c). on a daily basis d). only at the...
-
At year-end, December 31, 2014, Corolla Sales showed unadjusted balances of: $394,000 in Accounts Receivable; $13,800 debit in Allowance for Doubtful Accounts; and $1,940,000 in Sales. Uncollectible...
-
Convert functions to logic circuits: 3.1) f=(B+C+D) (A+C+D') (C'+D) 3.2) f=(CD)+(CD)+(ABD) 3.3) f=(A'C)+(A'D)+(B C') + (BD)
-
In Pittsburgh, Pennsylvania, about 56% of the days in a year are cloudy. Find the mean, variance, and standard deviation for the number of cloudy days during the month of June. Interpret the results...
-
For the equation (a) Find the transfer function and put it in standard gain/time constant form. (b) Discuss the qualitative form of the response of this system (independent of the input forcing) over...
-
Choose one of the four basic leader behavior styles suggested by Hersey and Blanchard. Discuss the specifics of the task and relationship behaviors of the chosen style. Provide a realistic example of...
-
Prior to @Home Network's merger with Excite for $6.7 billion, Excite's market value was about $3.5 billion. The new company combined the search engine capabilities of one of the best-known brands (at...
-
What are the key advantages of a deposit account over a money market account? What are the key advantages of a credit line with a bank over commercial paper issuance?
-
(30 Points) Consider the network in Figure-4 and Calculate the node-betweenness of node B and F. E F B Figure 4 C D
-
Identify the steps that employees at Fast Food follow in completing a work cycle (e.g., from taking an order to delivering a product). Is there improvements that might be made, particularly steps...
-
Unemployment and Inflation - End of Chapter Problem The accompanying table provides the inflation rate in the year 2005 and the average inflation rate over the period 2006-2019 for seven different...
-
Assume that there are two periods of consumption: Working years (time period 1) and retirement (time period 2). Because of the Social Security system, George receives an endowment of 100 units during...
-
1. If all the parameter mean, sample mean and standard deviation remain the same but sample size has increased, what will be the effect on value of test statistic z? 2. If all other parameters remain...
-
we have to compute the letter grades for a course. The data is a collection of student records stored in a file. Each record consists of a name(up to 20 characters), ID (8 characters), the scores of...
-
To what amount will the following investments accumulate? a. $6,000 invested for 12 years at 12 percent compounded annually b. $7,500 invested for 8 years at 8 percent compounded annually c. $6,400...
-
What is the present value of the following future amounts? a. $805 to be received 10 years from now discounted back to the present at 10 percent b. $376 to be received 5 years from now discounted...
-
At what annual rate would the following have to be invested? a. \($820\) to grow to \($1,988.12\) in 13 years b. \($320\) to grow to \($423.10\) in 6 years c. \($57\) to grow to \($290.30\) in 18...
Study smarter with the SolutionInn App