Consider a small growing company that distributes kitchen supplies. Customers are primarily small retailers such as kitchen specialty stores, hardware stores, and other types of home retail stores. Managers keep track of all customers, orders, and inventory information using a spreadsheet.
- Identify and describe one operational level decision, one managerial level decision, one strategic decision that can be made within this company. Explain your reasoning briefly.
- Describe two types of reports that can be produced by an MIS to help managers make recurring decisions in managing a function or the entire business. Use the context of the business scenario, provide an example of each type.
In: Computer Science
Raintree Cosmetic Company sells its products to customers on a
credit basis. An adjusting entry for bad debt expense is recorded
only at December 31, the company’s fiscal year-end. The 2020
balance sheet disclosed the following:
| Current assets: | ||
| Receivables, net of allowance for uncollectible accounts of $44,000 | $ | 502,000 |
During 2021, credit sales were $1,820,000, cash collections from customers $1,900,000, and $53,000 in accounts receivable were written off. In addition, $4,400 was collected from a customer whose account was written off in 2020. An aging of accounts receivable at December 31, 2021, reveals the following:
| Percentage of Year-End | Percent | |||
| Age Group | Receivables in Group | Uncollectible | ||
| 0−60 days | 65 | % | 4 | % |
| 61−90 days | 15 | 10 | ||
| 91−120 days | 15 | 30 | ||
| Over 120 days | 5 | 50 | ||
Required:
1. Prepare summary journal entries to account for
the 2021 write-offs and the collection of the receivable previously
written off.
2. Prepare the year-end adjusting entry for bad
debts according to each of the following situations:
3. For situations (a)−(c) in requirement 2
above, what would be the net amount of accounts receivable reported
in the 2021 balance sheet?
In: Accounting
Elsa is a data analytics intern at a financial firm.
Her company has obtained their customers bank transaction records
recently. Elsa has been asked by her manager to find out all the
attributes (variables) that can be delivered from those bank
transaction records for creating the machine learning algorithm.
The machine learning algorithm will help Elsa's firm to determine
whether someone is likely to get a loan approval or not.
List 5 attributes (variables) and explain why they should be
considered in the Machine Learning Assignment
In: Finance
The distribution system for the Herman Company consists of three plants, two warehouses, and four customers. Plant capacities and shipping costs per unit (in $) from each plant to each warehouse are as follows:
Warehouse
Plant 1 2 Capacity
1 4 7 450
2 8 5 600
3 5 6 380
Customer
Warehouse 1 2 3 4
1 6 4 8 4
2 3 6 7 7
Demand 300 300 300 400
Formulate the linear programming model to minimize the cost of shipping for this transshipment problem.
A-at the optimal solution how much is shipped from Plant 3 to Warehouse 1?
B-what is the range of optimality of coefficient of cost from Plant 3 to Warehouse 1 and what does this
mean?
C-what is the range of feasibility for the supply amount for Plant 2 and what does it mean?
D-what is the range of feasibility for the demand amount for customer 2 and what does it mean?
In: Operations Management
Bird's Eye Treehouses, Inc., a Kentucky company, has determined that a majority of its customers are located in the Pennsylvania area. Therefore, it is considering using a lockbox system offered by a bank located in Pittsburgh. The bank has estimated that use of the system will reduce collection time by 2 days. Average number of payments per day 870 Average value of payment $ 820 Variable lockbox fee (per transaction) $ .20 Annual interest rate on money market securities 4.6 % a. What is the NPV of the new lockbox system? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Suppose in addition to the variable charge that there is an annual fixed charge of $4,000 to be paid at the end of each year. What is the NPV now? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) (please explain)
In: Finance
Raintree Cosmetic Company sells its products to customers on a
credit basis. An adjusting entry for bad debt expense is recorded
only at December 31, the company’s fiscal year-end. The 2017
balance sheet disclosed the following:
| Current assets: | ||
| Receivables, net of allowance for uncollectible accounts of $42,000 | $ | 492,000 |
During 2018, credit sales were $1,810,000, cash collections from customers $1,890,000, and $51,000 in accounts receivable were written off. In addition, $4,200 was collected from a customer whose account was written off in 2017. An aging of accounts receivable at December 31, 2018, reveals the following:
| Percentage of Year-End | Percent | |||
| Age Group | Receivables in Group | Uncollectible | ||
| 0–60 days | 70 | % | 5 | % |
| 61–90 days | 20 | 15 | ||
| 91–120 days | 5 | 20 | ||
| Over 120 days | 5 | 40 | ||
Required:
1. Prepare summary journal entries to account
for the 2018 write-offs and the collection of the receivable
previously written off.
2. Prepare the year-end adjusting entry for bad
debts according to each of the following situations:
3. For situations (a)–(c) in requirement 2 above, what would be the net amount of accounts receivable reported in the 2018 balance sheet?
In: Accounting
|
Bird's Eye Treehouses, Inc., a Kentucky company, has determined that a majority of its customers are located in the Pennsylvania area. It therefore is considering using a lockbox system offered by a bank located in Pittsburgh. The bank has estimated that use of the system will reduce collection time by 2 days. Assume 365 days a year. |
| Average number of payments per day | 770 | ||
| Average value of payment | $ | 720 | |
| Variable lockbox fee (per transaction) | $ | .20 | |
| Annual interest rate on money market securities | 5.3 | % | |
| a. |
What is the NPV of the new lockbox system? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) |
|||||||||
| b. |
Suppose in addition to the variable charge that there is an annual fixed charge of $4,000 to be paid at the end of each year. What is the NPV now? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) |
|||||||||
|
||||||||||
In: Finance
A local T-shirt company is running a promotion as follows: For customers that buy less than 5 TShirts, there is no disconut. If a customer buys: between 6 and 10 Tshirts they get 10% discount. between 11 and 20 TShirts they get 20% discount. between 21 and 100 TShirts they get 50% discount. Write a C++ program that prompts the user for a number of TShirts. Assuming that a TShirt costs $10, calculate the appropriate discounts and display the number of TShirts bought, total amount, discount amount, and total amount due. For example, if the user bought 11 TShirts, the program should display the following: Number of TShirts bought: 11 Total amount : $ 110 Discount amount : $ 22 Total amount due : $ 88 If the user enters negative values or a 0 for number ofTshirts display an error message and ask them to run the program again.
In: Computer Science
|
Bird's Eye Treehouses, Inc., a Kentucky company, has determined that a majority of its customers are located in the Pennsylvania area. It therefore is considering using a lockbox system offered by a bank located in Pittsburgh. The bank has estimated that use of the system will reduce collection time by 1.5 days. Assume 365 days a year. |
| Average number of payments per day | 860 | ||
| Average value of payment | $ | 810 | |
| Variable lockbox fee (per transaction) | $ | .15 | |
| Annual interest rate on money market securities | 4.8 | % | |
| a. |
What is the NPV of the new lockbox system? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) |
| b. | Suppose in addition to the variable charge that there is an annual fixed charge of $5,000 to be paid at the end of each year. What is the NPV now? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) |
In: Finance
Comcast, Inc. (the cable tv company) is trying to determine the Lifetime Value of its customers. Here are some facts related to Comcast customers: - A study of historical sales data reveals that the average customer brings in about $2500 of sales revenues each year. - A study of historical cost data reveals that the average cost to service and retain a customer is about $700 per year. - Comcast spends about $500 to acquire a new customer, on average. - Comcast retains approximately 75% of its customers from one year to the next. - Comcast's discount rate is 7%. --
a. Calculate the Lifetime Value of a Comcast customer using the infinite time horizon version of the CLV formula.
b. How does your answer to a. change if year-to-year customer retention drops to 50% (and everything else stays the same)? c. What is the maximum amount Comcast can spend to acquire a customer and still maintain a positive Customer Lifetime Value (CLV)? (use the original assumptions above and ignore the fact that Comcast currently spends $500 to acquire a customer)
In: Operations Management