Oakley Wholesale Hardware and Supplies (OWHS) sells tools, lumber, and other remodeling supplies to commercial contractors....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Oakley Wholesale Hardware and Supplies (OWHS) sells tools, lumber, and other remodeling supplies to commercial contractors. The company controller is compiling cash and other budget information for July, August, and September. On June 30, the company had inventories of $500,000. OWHS sells a wide variety of products, but for budgeting and inventory planning purposes, the company has developed a standard "unit" of inventory that reflects roughly the mix and purchase costs of the items found in inventory and expected sales volume. The inventory value of $500,000 reported above is based on these inventory units. Each inventory unit is assumed to have a purchase price from vendors (for planning purposes) of $40. This number is not expected to change in the next three months. The budget is to be based on the following assumptions: • Each month's sales are billed on the last day of the month. • Customers are allowed a 5 percent discount if payment is made within 10 days after the billing date. Receivables are recorded in the accounts at their gross amounts (not net of discounts). • The billings are collected as follows: 75 percent within the discount period, 15 percent by the end of the month, and 8 percent by the end of the following month. Two percent is uncollectible. Purchase data are as follows: • For both purchases of inventory merchandise and selling, general, and administrative expenses, 70 percent is paid in the month purchased and the remainder in the following month. The number of units in each month's ending inventory equals 90 percent of the next month's units of sales. • Selling, general, and administrative expenses, of which $23,000 is depreciation, equal 20 percent of the current month's sales. • Actual and projected sales follow: May June July August September October Dollars $ 690,400 706,000 695,200 664,800 699,000 710,400 Units 22,200 22,600 22,400 21,600 22,500 22,800 Required: a. Compute the budgeted inventory purchases in dollars for July. b. Compute the budgeted inventory purchases in dollars for August. c. Compute the budgeted cash collections during July. Note: Do not round intermediate calculations. Round your final answer to nearest whole dollar. d. Compute the budgeted cash disbursements during August. Note: Do not round intermediate calculations. Round your final answer to nearest whole dollar. e. Compute the budgeted number of units of inventory to be purchased during September. Oakley Wholesale Hardware and Supplies (OWHS) sells tools, lumber, and other remodeling supplies to commercial contractors. The company controller is compiling cash and other budget information for July, August, and September. On June 30, the company had inventories of $500,000. OWHS sells a wide variety of products, but for budgeting and inventory planning purposes, the company has developed a standard "unit" of inventory that reflects roughly the mix and purchase costs of the items found in inventory and expected sales volume. The inventory value of $500,000 reported above is based on these inventory units. Each inventory unit is assumed to have a purchase price from vendors (for planning purposes) of $40. This number is not expected to change in the next three months. The budget is to be based on the following assumptions: • Each month's sales are billed on the last day of the month. • Customers are allowed a 5 percent discount if payment is made within 10 days after the billing date. Receivables are recorded in the accounts at their gross amounts (not net of discounts). • The billings are collected as follows: 75 percent within the discount period, 15 percent by the end of the month, and 8 percent by the end of the following month. Two percent is uncollectible. Purchase data are as follows: • For both purchases of inventory merchandise and selling, general, and administrative expenses, 70 percent is paid in the month purchased and the remainder in the following month. The number of units in each month's ending inventory equals 90 percent of the next month's units of sales. • Selling, general, and administrative expenses, of which $23,000 is depreciation, equal 20 percent of the current month's sales. • Actual and projected sales follow: May June July August September October Dollars $ 690,400 706,000 695,200 664,800 699,000 710,400 Units 22,200 22,600 22,400 21,600 22,500 22,800 Required: a. Compute the budgeted inventory purchases in dollars for July. b. Compute the budgeted inventory purchases in dollars for August. c. Compute the budgeted cash collections during July. Note: Do not round intermediate calculations. Round your final answer to nearest whole dollar. d. Compute the budgeted cash disbursements during August. Note: Do not round intermediate calculations. Round your final answer to nearest whole dollar. e. Compute the budgeted number of units of inventory to be purchased during September.
Expert Answer:
Answer rating: 100% (QA)
Calculation of effective collection rate Collection within discount period 7500 Discount rate 500 Effective rate of collection 7125 0751005 Sales budg... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Supply Chain management is a very important aspect within business operation to make sure that the company is able to operate and meet the marketing demands. It is also important to consider that...
-
The market supply curve for a perfectly competitive industry is the horizontal summation of each individual firms supply curve. Draw the market supply curve for a perfectly competitive industry.
-
Supply chain management has enabled some companies to operate more efficiently and compete more effectively on a global basis. What inherent characteristics of supply chain management contribute to...
-
A 0.20-m-diameter, thin-walled steel pipe is used to transport saturated steam at a pressure of 20 bars in a room for which the air temperature is 25C and the convection heat transfer coefficient at...
-
Distinguish between operational CRM systems and analytical CRM systems?
-
Apex Company prepared the statement of cash flows for the current year that is shown below: Required: Compute Apex Companys free cash flow for the current year. ompany Statement of Cash...
-
On April 20, 1992, Daniel Hubbard (plaintiff), a potato farmer, and UTZ Quality Foods, Inc. (UTZ) (defendant), a potato chip manufacturer, entered an installment contract under which Hubbard agreed...
-
The Gleaming Company has just developed a new dishwashing liquid and is preparing for a national television promotional campaign. The firm has decided to schedule a series of 1-minute commercials...
-
Design Deterministic Finite Automata with for each of the following independent specifications. Design a DFA that accepts the words that have odd number of's. Design a DFA where the members of has at...
-
Exhibit 4 in the case shows the average cost per passenger for British Airways. Classify the listed operating expenses per passenger as fixed or variable. (Note: Assume aircraft capacity is fixed....
-
A stock has no dividends. Last period's FCFE is $5.8 and it has an estimated annual free cash flow growth rate of 7.23%. The required return for this stock is 10.66% and its long term growth rate is...
-
Provide a summary of the company scenario. Complete a targeted risk assessment for the case scenario using the matrix provided with the case. Recommend at least one prevention strategy. Summarize the...
-
Watch the video below titled, "What is the Bible" by the Bible Society. Video Link: https://youtu.be/XEjDiMjkVRo Take down some notes to be able to answer the following instructions: 1. Identify 3...
-
On 1/1/X1, a company pays $1,000,000 to retire its bonds early. At retirement, the bonds have a face value of $930,000 and a carrying value of $950,000. Question: What should be the amount of gain or...
-
Karen lives in kirkland and drives every day into seattle to her administrative job at the university of washington. what would be the tax treatment of her daily commute?
-
How are the 6 limb leads (avL, avR, avF, Lead I, Lead II, and Lead III) derived from four limb electrodes? Describe electrocardiographic RULES and physics as to how this occurs. You may find defining...
-
Consider the following information. Each fund is actively-managed. Year Wolverine Fund Manager Sara Frank Frank Frank Frank Buckeye Fund Manager Julie Julie Steve Steve Steve Wolverine fund Return...
-
On average there are four traffic accidents in a city during one hour of rush-hour traffic. Use the Poisson distribution to calculate the probability that in one such hour there arc (a) No accidents...
-
Give an arithmetical example to illustrate diseconomies of scale.
-
Identify the three states of the economy in terms of TE and TP.
-
Government can use taxes and subsidies to change an inefficient market outcome into an efficient outcome. Do you agree or disagree? Explain your answer.
-
Why may some people consider this to be incorrect? That is, why is the fact that the control account is kept in the General Ledger not enough to justify saying that the control account is part of the...
-
From the following figures, compile accounts receivable ledger and accounts payable ledger control accounts for the month, and ascertain what the net balances of the respective ledgers should be on...
-
The financial year of The Better Trading Company ended on 30 November 2014. You have been asked to prepare a Total Accounts Receivable Account and a Total Accounts Payable Account in order to produce...
Study smarter with the SolutionInn App