Mr. Raju just appointed as an account manager at NH Sdn Bhd, a retail company selling merchandises for local market. Mr. Raju is being responsible to prepare and monitor the budget and expenses of the company business. Currently the company is preparing the quarterly budget as of 31 December 2020 and he has been asked by Ms. Sally, the owner of the company, to prepare a master budget. The sales forecast for the merchandises are provided as follows:
Unit sales | |
August 2020 | 1,500 actual |
September 2020 | 1,600 actual |
October 2020 | 1,700 budgeted |
November 2020 | 2,300 budgeted |
December 2020 | 2,400 budgeted |
January 2021 | 1,300 budgeted |
The average selling price and the average purchase price per unit are RM250 and RM120 respectively. As for desired ending inventory is expected 30% of next month’s unit sales. Collections from customers will be 20% in month of sale, 50% in month after sale and 30% two months after sale.
As for projected cash payments, inventory purchases will be paid in the month following acquisition. Meanwhile, variable cash expenses are equal to 35% of each month’s sales and paid in the month of sale. Fixed cash expenses are RM20,000 per month and are paid in the month incurred. Depreciation on equipment is RM2,000 per month. Desired ending cash balance per month will be RM20,000.
NH Sdn Bhd also has provided the following information at 30 September 2020
Balance Sheet as at 30 September 2020
RM | |
Cash | 30,000 |
Account Receivable | 245,000 |
Merchandise inventory(650 unit) | 78,000 |
Fixed Assets (net) | 110,000 |
Total assets | 463,800 |
Account Payable(Merchandise) | 148,800 |
Owner’s Equity | 315,000 |
Total liability and equity | 463,800 |
Required:
Based on the information given, you are required to prepare the following budget** for the upcoming quarter ending 31 December 2020.
In: Accounting
Mr. Raju just appointed as an account manager at NH Sdn Bhd, a retail company selling merchandises for local market. Mr. Raju is being responsible to prepare and monitor the budget and expenses of the company business. Currently the company is preparing the quarterly budget as of 31 December 2020 and he has been asked by Ms. Sally, the owner of the company, to prepare a master budget. The sales forecast for the merchandises are provided as follows:
|
Unit sales |
|
|
August 2020 |
1,500 actual |
|
September 2020 |
1,600 actual |
|
October 2020 |
1,700 budgeted |
|
November 2020 |
2,300 budgeted |
|
December 2020 |
2,400 budgeted |
|
January 2021 |
1,300 budgeted |
The average selling price and the average purchase price per unit are RM250 and RM120 respectively. As for desired ending inventory is expected 30% of next month’s unit sales. Collections from customers will be 20% in month of sale, 50% in month after sale and 30% two months after sale.
As for projected cash payments, inventory purchases will be paid in the month following acquisition. Meanwhile, variable cash expenses are equal to 35% of each month’s sales and paid in the month of sale. Fixed cash expenses are RM20,000 per month and are paid in the month incurred. Depreciation on equipment is RM2,000 per month. Desired ending cash balance per month will be RM20,000.
NH Sdn Bhd also has provided the following information at 30 September 2020
Balance Sheet as at 30 September 2020
|
RM |
|
|
Cash |
30,000 |
|
Account Receivable |
245,000 |
|
Merchandise inventory(650 unit) |
78,000 |
|
Fixed Assets (net) |
110,000 |
|
Total assets |
463,800 |
|
Account Payable(Merchandise) |
148,800 |
|
Owner’s Equity |
315,000 |
|
Total liability and equity |
463,800 |
Required:
Based on the information given, you are required to prepare the following budget** for the upcoming quarter ending 31 December 2020.
In: Accounting
Metlock Inc., a registered broker, enters into a finder’s fee
agreement with HOM Homes Ltd. on June 15, 2020. Metlock will find
leads in the form of buyers potentially interested in purchasing
HOM’s real estate holdings. Along with finding potential buyers,
Metlock helps negotiate the selling price and provides advice on
contract details. If and when HOM closes a sale, Metlock will be
paid within 30 days of the closing date, based on the following
formula: 5% of any transaction value up to and including $1
million, plus 4% of any transaction value greater than $1 million
and less than and including $2 million, plus 3% of any transaction
value greater than $2 million and less than and including $3
million, plus 2% of any transaction value greater than $3 million
and less than and including $4 million, plus 1% of any transaction
value in excess of $4 million. If Metlock is represented by another
broker and this information is not shared with HOM, the fee is
reduced by 50%. On September 1, 2020, HOM paid Metlock $51,000 to
provide some needed cash flow for seeking out buyers. On October
15, 2020, an offer was made and accepted for a parcel of real
estate at a price of $3.50 million. The transaction closed on
November 1, 2020, and Metlock was paid the finder’s fee net of
$51,000 on November 30, 2020.
Determine the accounting treatment of the above events for Metlock
Inc. and prepare any journal entries needed on: (Credit
account titles are automatically indented when the amount is
entered. Do not indent manually. If no entry is required, select
"No Entry" for the account titles and enter 0 for the
amounts.)
| a. | June 15, 2020 | |
| b. | September 1, 2020 | |
| c. | October 15, 2020 | |
| d. | November 1, 2020 | |
| e. | November 30, 2020 |
|
Date |
Account Titles and Explanation |
Debit |
Credit |
||
| a. |
|
||||
| b. | |||||
| c. |
|
||||
| d. |
|
||||
| e. | |||||
List of Accounts
In: Accounting
1. Derby Phones is considering the introduction of a new model of headphones with the following price and cost characteristics:
| Sales price | $ | 19 | per unit |
| Variable costs | 6 | per unit | |
| Fixed costs | 20,000 | per month | |
Assume that the projected number of units sold for the month is 6,000. Consider requirements (b), (c), and (d) independently of each other.
Required:
a. What will the operating profit be?
b. What is the impact on operating profit if the sales price decreases by 10 percent? Increases by 20 percent? (Do not round intermediate calculations.)
c. What is the impact on operating profit if variable costs per unit decrease by 10 percent? Increase by 20 percent? (Do not round intermediate calculations.)
d. Suppose that fixed costs for the year are 10 percent lower than projected, and variable costs per unit are 10 percent higher than projected. What impact will these cost changes have on operating profit for the year? Will profit go up? Down? By how much? (Do not round intermediate calculations.)
2. On-the-Go, Inc., produces two models of traveling cases for laptop computers: the Programmer and the Executive. The bags have the following characteristics:
| Programmer | Executive | |||||
| Selling price per bag | $ | 60 | $ | 100 | ||
| Variable cost per bag | $ | 20 | $ | 40 | ||
| Expected sales (bags) per year | 7,000 | 10,500 | ||||
The total fixed costs per year for the company are $667,000.
Required:
a. What is the anticipated level of profits for the expected sales volumes?
b. Assuming that the product mix is the same at the break-even point, compute the break-even point. (Round your final answer up to the nearest whole unit.)
c. If the product sales mix were to change to nine Programmer-style bags for each Executive-style bag, what would be the new break-even volume for On-the-Go? (Round your final answer up to the nearest whole unit.)
In: Accounting
some nations are better than others in innovation and creativity. Explain this in 300-400 words ( please donot copy from internet
In: Economics
How do you believe the term "quality" in health care will evolve as technology and innovation continue to shape health care services?
In: Nursing
Identify three conditions that would need to be implemented (or have already been implemented) in your organization to create a culture of innovation and change.
In: Operations Management
Identify three conditions that would need to be implemented (or have already been implemented) in your organization to create a culture of innovation and change.
In: Operations Management
Identify three conditions that would need to be implemented (or have already been implemented) in your organization to create a culture of innovation and change.
In: Operations Management
In what ways does Amazon promote innovation and entrepreneurship in each function of the value chain in addition to creation of new products? Explain
In: Economics