Given the six-month merchandise budget below, answer questions #1-4. When completing the budget, do not round...
|
Given the six-month merchandise budget below, answer questions #1-4. When completing the budget, do not round to the nearest whole dollar (in other words, do not drop the cents) 3. What is the “Total $ Planned Purchases at Retail” figure? |
Last Year’s Total Sales = $100,000
Planned % Sales Increase = 5%
Planned % Reductions = 14%
Planned EOM for Period = $25,000
Planned IMU% for Period = 53%
|
Six-Month Merchandise Budget |
|||||||
|
Spring/Summer |
February |
March |
April |
May |
June |
July |
Totals |
|
Planned Sales |
|||||||
|
Planned Sales % |
10% |
25% |
20% |
20% |
15% |
10% |
100% |
|
Planned BOM Stock |
____________ |
||||||
|
Planned S/S Ratio |
2.70 |
2.30 |
1.96 |
1.85 |
1.87 |
2.20 |
____________ |
|
Planned EOM Stock |
____________ |
||||||
|
Planned Reductions |
|||||||
|
Planned Reductions % |
10% |
15% |
20% |
22% |
18% |
15% |
100% |
|
Planned Purchases @ Retail |
|||||||
|
Planned Purchases @ Cost |
|||||||
| A. |
$116,350 |
|
| B. |
$112,000 |
|
| C. |
$54,684.50 |
|
| D. |
$155,500 |
Homework Answers
Soln : Here please refer the table , we can calculate the Planned Purchases @ Retail = Planned Sales +Reductions + Planned EOM - Planned BOM stock
Planned BOM stock = Planned Sales * Planned S/S ratio
Planned sales = We are considering Total of 100000*5% increase = 105000 for the 6 months given.
Planned reductions = Planned sales in month * % of reduction given
|
|
Add Answer to:
Given the six-month merchandise budget below, answer
questions #1-4. When completing the budget, do not round...
PLANNING EXERCISE INSTRUCTIONS FILL IN THE MISSING INFORMATION MANAS INCREASE IN SALES OVER LAST YEAR.PL 7...
PLANNING EXERCISE INSTRUCTIONS FILL IN THE MISSING INFORMATION MANAS INCREASE IN SALES OVER LAST YEAR.PL 7 2 6 MONTH MERCHANDISE PLAN STOCK TO SALES 1.6 L PLANNED REDUCTIONS % 10% SPRING 20 FEB $16,500 LAST YEAR 1.0 15% MAR 1.5 15% APR 1. 15% MAY 1.6 20% 25% JUN $32,000 $18,000 $15.000 $38,500 $40,000 $160.000 CHANGE $25,000 $58,500 $30,000 $28,500 $85,000 $65,000 $292,000 LAST YEAR RETAIL STOCK (BOM) $58,500 $30,000 $28,600 $85,000 $65,000 $45,000 $312.000 $40.000 EOM) XCHANGE $1,650 $...
Required: Prepare a master budget for the three-month period ending June 30. Include the following detailed...
Required: Prepare a master budget for the three-month period ending June 30. Include the following detailed schedules: 1. a. A sales budget, by month and in total. b. A schedule of expected cash collections, by month and in total. c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total. d. A schedule of expected cash disbursements for merchandise purchases, by month and in total. 2. A cash budget. Show the budget by...
Completing a master budget Problem 8-31 Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10]...
Completing a master budget
Problem 8-31 Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: $ Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable Common...
Answer the next the questions using the following information Buchanan Home Goods purchases merchandise from suppliers...
Answer the next the questions using the following information Buchanan Home Goods purchases merchandise from suppliers for sale in its re budget for the 3rd quarter of the current year. It's Balance Sheet and other data 60 suppliers for sale in its retail store. The company is preparing its and other data about the store's operations are below Assets Cash Accounts Receivable (Net) Merchandise Inventory Property & Equip (Net) Total Assets Balance Sheet as of June 30th Liabilities and Stockholders'...
NEED HELP ON CASH DISBURSEMENTS, CASH BUDGET, INCOME STATEMENT AND BALANCE SHEET. INFO BELOW You have...
NEED HELP ON CASH DISBURSEMENTS, CASH BUDGET, INCOME STATEMENT
AND BALANCE SHEET.
INFO BELOW
You have just been hired as a new management trainee buy
earrings and limited, a distributor of earrings to various retail
outlet located in the shopping mall across the country. In the past
they company has done very little in the way of budgeting and at
certain times of the year has experienced a shortage of cash since
you are well trained in budgeting, you have...
ONLY 2, 3, and 4. Already solved 1. Case 8-33 Master Budget with Supporting Schedules [LO8-2,...
ONLY 2, 3, and 4. Already solved 1.
Case 8-33 Master Budget with Supporting Schedules [LO8-2, LO8-4, LO8-8, LO8-9, LO8-10] You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained...
1. 2. A cash budget, by quarters, is given below for a retail company (000 omitted)....
1.
2.
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) Cash Budget 1 Quarter (000 omitted) 2 3 4 Year Cash balance, beginning Add collections from customers Total cash available 99 348 I Less disbursements: Purchase...
. Deacon Company is a merchandising company that is preparing a budget for the three-month period...
.
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 68,800 34,000 64,600 122,000 $ 289,400 $ 96,500 70,000 122,900 $ 289,400 Budgeted Income Statements April Sales $182,000 Cost of goods...
Part B: Comprehensive Master Budget Allenby's CEO decided to apply the new budget approach in preparing...
Part B: Comprehensive Master Budget Allenby's CEO decided to apply the new budget approach in preparing comprehensive budgets for the upcoming second quarter. The following information is assembled from accounting and other business areas. The company sells many styles of earrings, but all are sold for the same price, i.e. $12 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings): January (actual) 22 000 June...
Case 8-33 Master Budget with Supporting Schedules (LO8-2, LO8-4, LO8-8, LO8-9, LOB-101 You have just been...
Case 8-33 Master Budget with Supporting Schedules (LO8-2, LO8-4, LO8-8, LO8-9, LOB-101 You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a...
PLANNING EXERCISE INSTRUCTIONS FILL IN THE MISSING INFORMATION MANAS INCREASE IN SALES OVER LAST YEAR.PL 7 2 6 MONTH MERCHANDISE PLAN STOCK TO SALES 1.6 L PLANNED REDUCTIONS % 10% SPRING 20 FEB $16,500 LAST YEAR 1.0 15% MAR 1.5 15% APR 1. 15% MAY 1.6 20% 25% JUN $32,000 $18,000 $15.000 $38,500 $40,000 $160.000 CHANGE $25,000 $58,500 $30,000 $28,500 $85,000 $65,000 $292,000 LAST YEAR RETAIL STOCK (BOM) $58,500 $30,000 $28,600 $85,000 $65,000 $45,000 $312.000 $40.000 EOM) XCHANGE $1,650 $...
Required: Prepare a master budget for the three-month period ending June 30. Include the following detailed schedules: 1. a. A sales budget, by month and in total. b. A schedule of expected cash collections, by month and in total. c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total. d. A schedule of expected cash disbursements for merchandise purchases, by month and in total. 2. A cash budget. Show the budget by...
Completing a master budget
Problem 8-31 Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: $ Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable Common...
Answer the next the questions using the following information Buchanan Home Goods purchases merchandise from suppliers for sale in its re budget for the 3rd quarter of the current year. It's Balance Sheet and other data 60 suppliers for sale in its retail store. The company is preparing its and other data about the store's operations are below Assets Cash Accounts Receivable (Net) Merchandise Inventory Property & Equip (Net) Total Assets Balance Sheet as of June 30th Liabilities and Stockholders'...
NEED HELP ON CASH DISBURSEMENTS, CASH BUDGET, INCOME STATEMENT
AND BALANCE SHEET.
INFO BELOW
You have just been hired as a new management trainee buy
earrings and limited, a distributor of earrings to various retail
outlet located in the shopping mall across the country. In the past
they company has done very little in the way of budgeting and at
certain times of the year has experienced a shortage of cash since
you are well trained in budgeting, you have...
ONLY 2, 3, and 4. Already solved 1.
Case 8-33 Master Budget with Supporting Schedules [LO8-2, LO8-4, LO8-8, LO8-9, LO8-10] You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained...
1.
2.
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) Cash Budget 1 Quarter (000 omitted) 2 3 4 Year Cash balance, beginning Add collections from customers Total cash available 99 348 I Less disbursements: Purchase...
.
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 68,800 34,000 64,600 122,000 $ 289,400 $ 96,500 70,000 122,900 $ 289,400 Budgeted Income Statements April Sales $182,000 Cost of goods...
Part B: Comprehensive Master Budget Allenby's CEO decided to apply the new budget approach in preparing comprehensive budgets for the upcoming second quarter. The following information is assembled from accounting and other business areas. The company sells many styles of earrings, but all are sold for the same price, i.e. $12 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings): January (actual) 22 000 June...
Case 8-33 Master Budget with Supporting Schedules (LO8-2, LO8-4, LO8-8, LO8-9, LOB-101 You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago