Answer:
The quarterly deposit required is $ 20,578.36
Explanation:
in order to determine the needed quarterly deposit, we make use of pmt formula in excel, which is given as :
=-pmt(rate,nper,-pv,fv)
rate is the rate of return on the deposit at 8% per year but 2% per quarter(8%/4)
nper is number of deposits required in the fund,which number of years ,5 multiplied by 4(4 deposits per year)
pv is the present of the value of the future amount which is zero as it is not required.
Fv is the amount expected in 5 years which is $500,000
=-pmt(2%,20,0,500000)
pmt= $20,578.36
Answer:
Inventory would be 1, 768
Explanation:
2,000 goods
+200 freight-in (A)
-400 returned goods
<u> -32 </u> discount (B)
1, 768 net amount for inventory
<u>Notes:</u>
(A) The freight-in will be included in the inventory, as is a cost needed to have the inventory in the company's possession and be ready to use or sell.
(B) goods x discount rate
net goods 2,000 - 4,00 return = 1,600
discount for payment within 10 days 2%
Discount on purchase: 1,600 x 2% = 32
While figuring out how to save money for a bride who is having financial problems, Paula, the catering manager of Oh Happy Day, asked her assistant, "What do you think is the best menu to offer under these particular circumstances? How can we offer the bride and groom's guests a great meal within their budget?" Paula and her assistant are using the contingency approach.
True
Answer:
a. Sales for November = $192,666.67
b. Sales for December = $312,400,00
c. Total cash collections are as follows:
January = $200,580
February = $201,360
March = $191,750
Explanation:
a. Compute the sales for November.
Sales for November = (Accounts receivable balance at the end of the previous quarter - Uncollected sales from December) / Collection rate two months after the sale = ($107,000 - $78,100) / 15% = $192,666.67
b. Compute the sales for December.
Sales for December = Uncollected sales from December / (Collection rate one months after the sale + Collection rate two months after the sale) = $78,100 / (10% + 15%) = $312,400,00
c. Compute the cash collections from sales for each month from January through March.
Note: See the attached excel file for the schedule of cash collections from sales for each month from January through March.
From the attached excel file, total cash collections are as follows:
January = $200,580
February = $201,360
March = $191,750
Answer: 90.32%
Explanation:
Weekly demand (d) = 120
Standard deviation = 10
Lead time (l) = 4
Reorder point = 506
The reorder point is calculated as:
506 = 120 × 4 + Z × 10 × ✓4
Solving for Z will give us 1.3
Then, we check this in the z table which will give us p = 0.9032
Therefore, the service level is 90.32%.