Answer:
Periodic Inventory System
Journal Entries
April 4 Debit Accounts receivable $5,000
Credit Sales revenue $5,000
To record the sale of goods on credit, terms of 3/10, n/30.
April 5 Debit Sales returns $500
Credit Accounts receivable (cash) $500
To record the return of goods for a cash refund.
Explanation:
a) Data and Analysis:
April 4 Accounts receivable $5,000 Sales revenue $5,000 credit terms of 3/10, n/30.
April 5 Sales returns $500 Accounts receivable (cash) $500
b) The seller uses a periodic inventory system. Therefore, the cost of goods sold will not be recorded on April 4 until April 30, when there will be a physical count of inventory to determine the closing inventory. With the beginning and ending inventories together with the purchases account, the cost of goods sold can then be calculated.
Population and it’s distribution constitutes the target market for goods and services. This can be linked with ____________
A. Financial environment
B. Social environment
C. Political environment
D. Demographic environment
Population and it’s distribution constitutes the target market for goods and services. This can be linked with social environment.
Dmitri loves watching Downton Abbey on his local public TV station, but he never sends any money to support the station during its fundraising drives. Economists would call Dmitri a . True or False: The government cannot solve the problem caused by people like Dmitri. True False True or False: The private market can solve this problem by broadcasting Downton Abbey on cable TV, since then the good would be excludable and thus no longer a public good. True False
Your name is Joanne Warren, and you are writing a business plan for a coffee house that you plan to open in the downtown district of your city. Your business will be called A Cup of Joanne, and you plan to distinguish yourself from your competitors by offering blends from all around the world. You will also sponsor international coffee tastings and sell one-pound bags of freshly ground fair-trade coffee. The bank from which you are seeking to borrow $20,000 has asked you for a full business plan. ________ is/are not required in your business plan. Group of answer choices A business description and organization Sales strategies Interior decoration plans and merchandising Funding requirements and financial projections A market analysis
Answer: Interior decoration plans and merchandising
Explanation:
To approve a loan for a business there are several things that a bank needs to look at.
The relevant ones include:
The business description and organization so that they can understand what the business is all about. The sales strategies of the company so that they can understand how the company plans to gain an edge in the market and become profitable.The funding requirements and financial projections so that the bank understands how much is needed and whether the business will generate enough to pay back the loan. A market analysis so that the bank understands whether the coffee house will be able to survive to be able to pay off the loan.The way you design your coffee house (interior design) is of no concern to the bank and neither is the merchandise that you decide to buy. They just need to know that you can pay them back.
Smart Stream Inc. uses the variable cost concept of applying the cost-plus approach to product pricing. The costs of producing and selling 10,000 cellular phones are as follows: Variable costs per unit: Fixed costs: Direct materials $150 Factory overhead $350,000 Direct labor 25 Selling and admin. exp. 140,000 Factory overhead 40 Selling and administrative expenses 25 Total $240 Smart Stream desires a profit equal to a 30% rate of return on invested assets of $1,200,000. a. Determine the variable costs and the variable cost amount per unit for the production and sale of 10,000 cellular phones. Total variable costs $ fill in the blank 1 Variable cost amount per unit $ fill in the blank 2 b. Determine the variable cost markup percentage for cellular phones. Round to two decimal places. fill in the blank 3 % c. Determine the selling price of cellular phones. If required round to the nearest dollar. $ fill in the blank 4 per phone
Answer:
Smart Stream Inc.
1. Total variable costs = $2,400,000
2a. Variable cost per unit = $240
2b. The variable cost markup percentage = 12.46%
2c. Selling price per unit = $325
Explanation:
a) Data and Calculations:
Variable costs per unit:
Direct materials $150
Direct labor 25
Factory overhead 40
Selling and administrative expenses 25
Total $240
Fixed costs:
Factory overhead $350,000
Selling and admin. exp. 140,000
Total fixed costs = $490,000
Smart Stream desires a profit equal to a 30% rate of return on invested assets of $1,200,000
Profit target = $360,000 ($1,200,000 * 30%)
Total variable costs = $2,400,000 ($240 * 10,000)
Variable cost per unit = $240
b. The variable cost markup percentage =
Variable cost markup = $360,000 * $2,400,000/$2,890,000 = $298,962
Variable cost markup percentage = $298,962/$2,400,000 * 100 = 12.46%
Fixed cost markup = $360,000 * $490,000/$2,890,000 = $61,038
Total cost = $2,890,000
Target profit 360,000
Total sales revenue = $3,250,000
Selling price = $325 ($3,250,000/10,000)
Calculating the price elasticity of demand: A step-by-stepguideSuppose that during the past year, the price of a laptop computer rose from $2,950 to $3,110. During the same time period, consumer sales decreased from 468,000 to 296,000 laptops.Calculate the elasticity of demand between these two price–quantity combinations by using the following steps. After each step, complete the relevant part of the table with the appropriate answers. (Note: For decreases in price or quantity, enter values in the Change column with a minus sign.)Original New Average Change Percentage ChangeQuantity a. -45.03%
b. -22.51%
c. 222.09%Price a. 1,893.75% b. 5.28% c. 2.64%Step 1: Fill in the appropriate values for original quantity, new quantity, original price, and new price.Step 2: Calculate the average quantity by adding the original quantity and the new quantity, and then dividing by two. Do the same for the average price.Step 3: Calculate the change in quantity by subtracting the original quantity from the new quantity. Do the same for the change in price.Step 4: Calculate the percentage change in quantity demanded by dividing the change in quantity by the average quantity. Do the same to calculate the percentage change in price.Step 5: Calculate the price elasticity of demand by dividing the percentage change in quantity demanded by the percentage change in price, ignoring the negative sign.Using the midpoint method, the elasticity of demand for laptops is about
a. 0.12
b. 4.26
c. 8.53
d. 17.06
Answer:
original quantity = 468,000
Average quantity = 382,000
new quantity = 296,000
a. -45.03%
original price - $2,950
new price = $3,110
Average price = 3030
3. -172,000
$160
b. 5.28%
Explanation:
Price elasticity of demand measures the responsiveness of quantity demanded to changes in price of the good.
Price elasticity of demand = midpoint change in quantity demanded / midpoint change in price
Average quantity = (468,000 + 296,000) / 2 = 382,000
Average price = ($2,950 + $3,110) / 2 = 3030
Change in quantity = 296,000 - 468,000 = -172,000
Change in price = $3110 - $2950 = $160
percentage change in quantity demanded = (-172,000 / 382,000) x 100 = -0.4503 = -45.03%
percentage change in price = 160 / 3030 x 100 = 5.28%
Elasticity of demand = -45.03% / 5.28% = -8.53 = 8.53
A stock has an expected return of 11.85 percent, its beta is 1.24, and the expected return on the market is 10.2 percent. What must the risk-free rate be?
Answer:
3.325%
Explanation:
The computation of the risk free rate of return is shown below:
As we know that
Expected rate of return = risk free rate of return + beta × (market rate of return - risk free rate of return)
11.85% = Risk Free Rate + ( 10.2% - Risk Free Rate) × 1.24
11.85% = Risk Free Rate + 12.648% - 1.24 × Risk Free Rate
0.24 × Risk Free Rate = 12.648 % - 11.85%
Risk Free Rate= (12.648 % - 11.85%) ÷ 0.24
= 3.325%
In a particular setting where the newsvendor model applies, demand is Normally distributed and the critical ratio is 0.4. Then, if the profit maximizing quantity (i.e., the Newsvendor ordering quantity) were ordered:_________
a. the expected sales is less than expected demand;
b. the expected sales is greater than expected demand;
c. the expected sales is exactly equal to expected demand;
d. the expected sales could be less than, equal to or greater than expected demand.
Answer: C. the expected sales is exactly equal to expected demand;
Explanation:
The newsvendor model refers to the mathematical model that is used in the determination of optimal inventory levels. This model is characterized by uncertain demand and fixed prices for a good that's perishable e.g newspapers.
In this model, there can be a high profit only in a scenario whereby the demand and the supply is met. Therefore, if the profit maximizing quantity were ordered, the expected sales is exactly equal to expected demand.
With an aggregate supply function that is continually positively sloped (LRAS), a reduction in aggregate demand leads to: Group of answer choices Falling prices cost-push interest rate Perpetual growth Rising prices Falling Employment
Answer: Falling prices
Explanation:
When Aggregate demand reduces, the Aggregate demand curve will have to shift leftward to depict this and in doing so, it would intersect with the Long Run Aggregate Supply curve at a lower price level thereby leading to a fall in prices.
Aggregate demand reducing means that there is less money being spent in the economy and should this be the case, the economy is going to contract and unless the Aggregate demand was above potential GDP then this is not ideal.
For next year, Williams, Inc., has budgeted sales of 19,000 units, targeted ending finished goods inventory of 1,750 units, and beginning finished goods inventory of 1,250 units. All other inventories are zero. How many units should be produced next year
Answer:
Production= 19,500
Explanation:
Giving the following information:
Ending finished goods inventory of 1,750 units
Beginning finished goods inventory of 1,250 units.
Sales= 19,000
To calculate production, we need to use the following formula:
Production= sales + desired ending inventory - beginning inventory
Production= 19,000 + 1,750 - 1,250
Production= 19,500
Tin Roof's net cash flows for the next three years are projected at $72,000, $78,000, and $84,000, respectively. After that, the cash flows are expected to increase by 3.2 percent annually. The aftertax cost of debt is 6.2 percent and the cost of equity is 11.4 percent. What is the value of the firm if it is financed with 40 percent debt and 60 percent equity
Answer: $1282620.4
Explanation:
First, we'll calculate the weighted average cost of capital which will be:
= (Weight of debt × After cost of debt) + (Weight of equity × Cost of equity)
= (40% × 6.2%) + (60% × 11.4%)
= (0.4 × 0.062) + (0.6 × 0.114)
= 0.0248 + 0.0684
= 2.48% + 6.84%
= 9.32%
The present value calculated is $195424.56 (Check attachment)
Then, the terminal value for cash flow will be $1084195.40 (Check attachment)
Then, the value of the firm will be:
= Present value of cash flow + Terminal value for cash flow
= $195424.56 + $1084195.40
= $1282620.4
Therefore, the value of the firm is $1282620.40.
One disadvantage to terrorists of using radiological materials in weapons is: Select one: a. numerous difficult steps to assemble device. b. economic impact on affected areas. c. lethal effects depending on type of radiation source. d. the majority of jurisdictions within the United States are unprepared for any type of large incident involving radiological material.
Answer: a. numerous difficult steps to assemble device.
Explanation:
Radiological materials are quite cumbersome to assemble and require rare materials whose sale are intensely watched by various intelligence agencies in the world. Coupled with that is the need for very skilled scientists in order to assemble the device.
All these hurdles make it so that terrorists are not able to assemble radiological devices easily which is a good thing because if they could, it would have been used to devastating effect on many parts of the world by now.
Jones Ice Cream Stand is operated by Mr. Jones and experiences different sales patterns throughout the year. To plan for thefuture, Mr. Jones wants to determine its cost behavior patterns. He has the following information available about the ice creamstand's operating costs and the number of soft serve cones served
Using the high- low method , the fixed cost for a month are?
MONTH NUMBER OF ICE CREAM CONES TOTAL OPERATING COST
APRIL 800 950
MAY 825 975
JUNE 1125 1000
JULY 2000 1250
AUGUST 1500 1875
SEPTEMBER 900 1500
A) 2,200
B) 750
C) 300
Answer:
B) 750
Explanation:
The computation of the fixed cost using the high-low method is as follows:
But before that the variable cost per unit should be determined
Variable cost is
=[ ($1,250 - $950) ÷ (2000 - 800)]
= $0.25 per ice cream
Now the fixed cost is
= [$1,250 - ($0.25 × 2000)]
= $750
hence, the option b is correct
Aaron Co. needs a machine for a 5-year project. It can either (1) buy a machine without borrowing for $500,000 or (2) enter into a 5-year operating lease for an annual payment of $105,000. The machine has an estimated useful life of 5 years, after which it can be sold for $15,000. The average tax rate is 30%, and the discount rate for the project is 6%. Relevant discount factors are below: Present value of 1 at 6% in 1 year: 0.943 Present value of 1 at 6% in 2 years: 0.890 Present value of 1 at 6% in 3 years: 0.840 Present value of 1 at 6% in 4 years: 0.792 Present value of 1 at 6% in 5 years: 0.747 What is the present value of the relevant net cash outflows of the operating lease
Answer:
The present value of the relevant net cash outflows of the operating lease is $434,416.50.
Explanation:
Salvage value after tax = Salvage value * (100% - Tax rate) = $15,000 * (100% - 30%) = $10,500
Present value of salvage value after tax = Salvage value after tax * Present value of 1 at 6% in 5 years = $10,500 * 0.747 = $7,843.50
Present value of a Year annual operating lease = Annual operating * Present value of 1 at 6% in the years ………… (1)
Using equation (1), we have:
Present value of Year 1 annual operating lease = $105,000 * 0.943 = $99,015
Present value of Year 2 annual operating lease = $105,000 * 0.890 = $93,450
Present value of Year 3 annual operating lease = $105,000 * 0.840 = $88,200
Present value of Year 4 annual operating lease = $105,000 * 0.792 = $83,160
Present value of Year 5 annual operating lease = $105,000 * 0.747 = $78,435
Therefore, we have:
Present value of net cash outflows of the operating lease = Present value of Year 1 annual operating lease + Present value of Year 2 annual operating lease + Present value of Year 3 annual operating lease + Present value of Year 4 annual operating lease + Present value of Year 5 annual operating lease - Present value of salvage value after tax = $99,015 + $93,450 + $88,200 + $83,160 + $78,435 - $7,843.50 = $434,416.50
Therefore, the present value of the relevant net cash outflows of the operating lease is $434,416.50.
Economists experience difficulties in accurately measuring income inequality because of which of the following? Choose one or more: A. do-it-yourself production of goods and services (such as growing own food or making own clothing) that are not bought or sold in the market B. Measurements tend to use "before tax" income, not "after tax" income (disposable income), which is the income people actually have available to purchase goods and services. C. The Gini index calculation discriminates against the poor in developed economies. D. in-kind transfers where goods and services are given
Answer:
Economists experience difficulties in accurately measuring income inequality because of the following:
A. do-it-yourself production of goods and services (such as growing own food or making own clothing) that are not bought or sold in the market
Explanation:
With do-it-yourself production of goods and services, it is very difficult to measure income inequality. Income is measured as the value that is exchanged for goods and services in the marketplace, that is, by the forces of demand and supply. These marketplace forces cannot be objectively measured when goods and services are produced and consumed by the same person.
Reason why the Economists do encounter some difficulty in the process of measuring income inequality is as result of A :do-it-yourself production of goods and services (such as growing own food or making own clothing) that are not bought or sold in the market
Income inequality can be regarded as a way to measure unevenly income distribution among population. When the distribution is less equal, then the income inequality will be high, however some difficulties are been faced by Economist in taking this measurement such as situation whereby people make the goods they need by themselves instead of getting it from market.Therefore, option A is correct.
Learn more at:
https://brainly.com/question/12097372?referrer=searchResults
Assume that Tree Co. has the ability to discontinue both product lines and rent the factory space previously used for the production of Leaves and Bark. The factory space for Leaves can be rented out for $25,000 a year, and the factory space for Bark can be rented for $27,000 a year. Which product lines should Tree Co. discontinue and rent out instead?
Answer:
Both Leaves and Bark should be discontinued and rented out
Explanation:
Calculation to determine whether Both Leaves and Bark should be discontinued and rented out
LEAVES BARK
Sales eliminated $(30,000)$(50,000)
Variable costs eliminated $10,000 $25,000
Net loss from discontinuation($20,000)($25,000)
($-30,000+$10,000=-$20,000)
(-$50,000+$25,000=-$25,000)
Rental income gained $25,000 $27,000
Increase in operating income $5,000 $2,000
($25,000-$20,000=$5,000)
($27,000-$25,000=$2,000)
Therefore based on the above calculation both Leaves and Bark SHOULD BE DISCONTINUED reason been that the NET LOSS for each is LESSER than the annual rental income.
Companies U and L are identical in every respect except that U is unlevered and L has a debt of $10 million with the cost of debt rd being 5%. Assume that (1) all the MM assumptions are met, (2) all the firms are subject to a 40% tax rate, (3) EBIT is $2 million and (4) the unlevered cost of equity rsu is 10%. Based on MM model with corporate tax, what is the equity of the levered firm, i.e. what is SL
Answer:
The equity of the levered firm is $6 million.
Explanation:
Firm U value = Value of unlevered firm = (EBIT * (100% - Tax rate )) / Unlevered cost of equity = (2 * (100% - 40%)) / 10% = $12 million
Firm L value = Value of levered firm = Value of unlevered firm + (Debt * Tax rate) = 12 + (10 * 40%) = $16 million
This implies that:
SL = Equity of the levered firm = Value of levered firm - Debt = $16 - $10 = $6 million
Therefore, the equity of the levered firm is $6 million.
Outsourcing: Question 19 options: Transfers traditional internal activities to outside vendors. Utilizes the efficiency which comes with generalization. Reduces the chances that the outsourcing firm can focus on its key success factors. None of the above are true of outsourcing. All of the above are true of outsourcing.
Answer:
Transfers traditional internal activities to outside vendors.
Utilizes the efficiency which comes with generalization
Explanation:
Outsourcing can be regarded as a business practice which involves hiring a party from outside of the company so that the party can perform particular services as well as creation of goods which traditionally are been performed in-house by the employees and staff of the own company.Outsourcing helps in cost-cutting measure
It should be noted that Outsourcing ;
✓Transfers traditional internal activities to outside vendors.
✓Utilizes the efficiency which comes with generalization.
Selected operating data for two divisions of Outback Brewing, Ltd., of Australia are given below: Division Queensland New South Wales Sales $ 1,144,000 $ 2,220,000 Average operating assets $ 520,000 $ 600,000 Net operating income $ 125,840 $ 177,600 Property, plant, and equipment (net) $ 252,000 $ 202,000 Required: 1. Compute the rate of return for each division using the return on investment (ROI) formula stated in terms of margin and turnover. 2. Which divisional manager seems to be doing the better job?
Answer:
Outback Brewing, Ltd., of Australia
Queensland New South Wales
1. Rate of return 5% 2.16%
2. Based on the computed Rate of Return, Division Queensland seems to be doing a better job than New South Wales
Explanation:
a) Data and Calculations:
Queensland New South Wales
Sales $ 1,144,000 $ 2,220,000 Average operating assets $ 520,000 $ 600,000
Net operating income $ 125,840 $ 177,600
Property, plant, and equipment (net) $ 252,000 $ 202,000
Sales margin = 11% 8%
Capital turnover ratio = 2.2 3.7
Return on investment (ROI) = 5% 2.16%
Sales margin = Net operating income/Sales * 100
Capital turnover ratio = Sales/Average operating assets
ROI = Sales margins divided by the firm's capital turnover ratio
Blue Spruce Corp. gathered the following reconciling information in preparing its June bank reconciliation: Cash balance per books, 6/30 $14600 Deposits in transit 1000 Notes receivable and interest collected by bank 2580 Bank charge for check printing 85 Outstanding checks 5200 NSF check 490 The adjusted cash balance per books on June 30 is:_________.
a. $17585.
b. $17605.
c. $16605.
d. $17180.
Answer:
c. $16605
Explanation:
Calculation to determine what The adjusted cash balance per books on June 30 is:
Using this formula
Adjusted Cash Balance=Cash balance + Notes receivable - Check Printing - NSF Check
Let plug in the formula
Adjusted Cash Balance=$14600 + $2,580 - $85 - $490
Adjusted Cash Balance= $16605
Therefore The adjusted cash balance per books on June 30 is:$16605
Here are incomplete financial statements for Cullumber Company. Calculate the missing amounts.
CULLUMBER COMPANY
Balance Sheet
Assets
Cash $ 14,000 Inventory 17,000 Buildings 38,000 Total assets $69,000 Liabilities and Stockholders' Equity Liabilities Accounts payable $ 5,600 Stockholders' Equity Common stock enter a dollar amount
(a) Retained earnings enter a dollar amount
(b) Total liabilities and stockholders' equity $69,000 CULLUMBER COMPANY Income Statement Revenues $85,400 Cost of goods sold enter a dollar amount
(c) Salaries and wages expense 10,270 Net income $enter a dollar amount
(d) CULLUMBER COMPANY Retained Earnings Statement Beginning retained earnings $19,000 Add: Net income enter a dollar amount
(e) Less: Dividends 4,770 Ending retained earnings $34,000
Answer:
(a) Common Stock = $29,400. (b) Retained earnings = $34,000, (c) Cost of goods sold = $55,360, (d) Net Income = $19,770, (e) Net Income =$19,770
Explanation:
Note: See organized question as attached below to aid understanding
Net income = Ending retained earnings + Dividends - Beginning retained earnings
Net income = $34,000 + $4,770 - $19,000
Net income = $19,770
Net income = Revenue - Cost of goods sold - Salaries and wages expense
$19,770 = $85,400 - Cost of goods sold - $10,270
Cost of goods sold = $85,400 - $19,770 - $10,270
Cost of goods sold = $55,360
Total liabilities and stockholders equity = Accounts payable + Common stock + Retained earnings
$69,000 = $5,600 + Common stock + $34,000
Common stock = $69,000 - $5,600 - $34,000
Common stock = $29,400
Missing amounts :
Common Stock = $29,400
Retained earnings = $34,000,
Cost of goods sold = $55,360
Net Income = $19,770
Net Income = $19,770
Net income
= Ending retained earnings + Dividends - Beginning retained earnings
= $34,000 + $4,770 - $19,000
= $19,770
Net income
= Revenue - Cost of goods sold - Salaries and wages expense
$19,770 = $85,400 - Cost of goods sold - $10,270
Cost of goods sold
= $85,400 - $19,770 - $10,270
= $55,360
Total liabilities and stockholders equity
= Accounts payable + Common stock + Retained earnings
$69,000 = $5,600 + Common stock + $34,000
= $69,000 - $5,600 - $34,000
= $29,400
Learn more about calculation of retained earnings here: https://brainly.com/question/5709809
The following data apply to Benevento Industries, Inc. (BII): Value of operations $1,000 million Short-term investments $100 million Debt $300 million Number of shares 100 million The company plans on distributing $100 million as dividend payments. What will the intrinsic per share stock price be immediately after the distribution
Answer: $7
Explanation:
Firstly, we'll calculate the equity which will be:
= Value of operations - Value of debt
= $1000 - $300
= $700
Then, the intrinsic price will be:
= Equity/Number of shares
= $700/100
= $7
Therefore, the intrinsic per share stock price immediately after the distribution will be $7
The process mapping is a
____ diagram.
Answer:
I hope u understand and thank you for your questions
The discount rate is the interest rate banks charge their best customers. the interest rate banks charge each other for overnight loans. the interest rate the U.S. Treasury pays on Treasury Bills. the interest rate the Fed charges to banks for loans from the Fed.
an investor purchased a stock one year ago for $58.00. it paid an annual cash dividend of $4.38 and is now worth $65.01. what total return did the investor earn? would the investor have experienced a capital gain? explain.
Answer:
its 34
Explanation:
rytrfgfgfc
13. Social Entrepreneurs identify social needs such as
a. The arts and education
c. Shipping and operations
b. Internet and technology
d. Profit and loss
Help
Mhat do youmean by business? व्यापारराव्यवसाय भनेको के हो? यो कति :
Explanation:
A business is defined as an organization or enterprising entity engaged in commercial, industrial, or professional activities. ... The term "business" also refers to the organized efforts and activities of individuals to produce and sell goods and services for profit.
Your goal is to have $10,000 in your bank account by the end of 15 years. If the interest rate remains constant at 3% and you want to make annual identical deposits, how much will you need to deposit in your account at the end of each year to reach your goal? (Note: Round your answer for PMT to two decimal places.)
Answer:
the pmt is $537.67
Explanation:
The computation of the PMT amount is given below;
Given that
FV = $10,000
PV = $0
NPER = 15 years
RATE = 3%
The formula is shown below:
= PMT(RATE, NPER,PV,FV,TYPE)
AFter applying the above formula, the pmt is $537.67
The same should be considered and relevant
1) What are the three primary determinants of behavior in organizations?
Answer:
The three primary determinants of behavior in organizations are employee dynamics, available resources and work environments.
Acme, Inc., incurs the following costs during May:
Sales expense $ 12,100 Administrative expense $ 22,100
Direct labor 26,600 Plant depreciation 6,800
Factory supplies 3,100 Indirect labor 8,600
Advertising 3,400 Utilities 10,600
Raw material used 18,600
80% of this amount relates to the factory.
Required:
Calculate Acme�s total manufacturing costs for May.
Answer:
Particulars Amount
Raw material used $18,600
Add: Direct labor $26,600
Overhead costs
Factory supplies $3,100
Plant depreciation $6,800
Indirect labor $8,600
Utilities ($10,600*80%) $8,480
Total overhead cost $26,980
Total manufacturing costs $72,180
The Williams Supply Company sells for $50 one product that it purchases for $20. Budgeted sales in total dollars for the year are $3,000,000. The sales information needed for preparing the July budget follows:
Month Sales Revenue
May $ 175,000
June 240,000
July 295,000
August 320,000
Account balances at July 1 include these:
Cash $ 125,000
Merchandise inventory 47,200
Accounts receivable (sales) 84,530
Accounts payable (purchases) 47,200
The company pays for one-half of its purchases in the month of purchase and the remainder in the following month. End-of-month inventory must be 40% of the budgeted sales in units for the next month. A 2% cash discount on sales is allowed if payment is made during the month of sale. Experience indicates that 60% of the billings will be collected during the month of sale, 25% in the following month, 12% in the second following month, and 3% will be uncollectible. Total budgeted selling and administrative expenses (excluding bad debts) for the fiscal year are estimated at $1,200,000, of which three-fourths is fixed expense (inclusive of a $36,000 annual depreciation charge). Fixed expenses are incurred evenly during the year. The other selling and administrative expenses vary with sales. Expenses are paid during the month incurred.
Part A
Part B
Part C
Part D
(a) Prepare a schedule of estimated cash collections for July.
(b) Prepare a schedule of estimated July cash payments for purchases. Hint: Start by doing a purchase budget.
(c) Prepare schedules of July selling and administrative expenses, separately identifying those requiring cash disbursements.
(d) Prepare a schedule of cash receipts over disbursements assuming no equipment purchases or loan payments.
Answer:
The Williams Supply Company
a. Estimated Cash Collections for July
58% sales month (60% -2%) $171,100 ($295,000 * 58%) July
25% ffg month 60,000 ($240,000 * 25%) June
12% second month 21,000 ($175,000 * 12%) May
Estimated cash collections = $252,100
b. Estimated July Cash Payments for Purchases:
July
Cost of purchases $122,000
50% purchase month 61,000
50% ffg month 47,200
Total payment for purchases $108,200
c. July Selling and Administrative Expenses:
Monthly fixed expenses $72,000
Variable expenses ($5 * 5,900) 29,500
Total selling and admin expenses $101,500
d. Cash Receipts Over Disbursements for July:
Beginning cash balance $125,000
Total cash receipts 252,100
Total cash available $377,100
Cash Disbursements:
Purchases $108,200
Selling and Admin. 101,500
Total cash disbursements $209,700
Cash balance $167,400
Explanation:
a) Data and Calculations:
Selling price of product = $50 per unit
Purchase cost of product = $20 per unit
Total budgeted sales for the year = $3,000,000
Total budgeted sales for the year (units) = 60,000 units
Month Sales Revenue Unit Sales
May $175,000 3,500 ($175,000/$50)
June 240,000 4,800 ($240,000/$50)
July 295,000 5,900 ($295,000/$50)
August 320,000 6,400 ($320,000/$50)
July 1 Account Balances:
Cash = $125,000
Merchandise inventory = $47,200
Accounts receivable (sales) = $84,530
Accounts payable (purchases) = $47,200
Payment of Purchases:
50% purchase month
50% ffg month
Cash collections from sales:
58% sales month (60% -2%)
25% ffg month
12% second month
Ending inventory = 40% of the budgeted sales in units in the next month
Total budgeted selling and administrative expenses (excluding bad debts) = $1,200,000
Fixed expense = $864,000 ($1,200,000 * 3/4) - $36,000
Monthly fixed expenses = $72,000 ($864,000/12)
Variable selling expenses = $300,000 ($1,200,000 - $900,000)
Variable selling expenses per unit = $5 ($300,000/60,000)
Purchases Budget
June July
Ending inventory 2,360 2,560
Sales 4,800 5,900
Units available for sale 7,160 8,460
Beginning inventory 1,920 2,360
Purchases 5,240 6,100
Cost of purchases $104,800 $122,000 (6,100 * $20)