Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Units: Sales through stores |
54 | 54 | 34 | 34 | 34 | 34 | 34 | 22 | 0 | 0 | 0 | 0 |
Units : Sales through internet | 0 | 0 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 |
€ : sale through stores | 2430 | 2430 | 1530 | 1530 | 1530 | 1530 | 1530 | 900 | 0 | 0 | 0 | 0 |
Sales through internet | 0 | 0 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 |
Days of production | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 7 | 7 | 7 | 7 |
Production | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 20 | 20 | 20 | 20 |
Need of Fabric | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 10 | 10 | 10 | 10 |
Cost of fabric | 189 | 189 | 189 | 189 | 189 | 189 | 189 | 189 | 70 | 70 | 70 | 70 |
Cost of ornament | 270 | 270 | 270 | 270 | 270 | 270 | 270 | 270 | 100 | 100 | 100 | 100 |
Notes:
(1) it is assumed
Cash flow
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Intial balance | 0 | (8930) | (13703) | (14946) | (16189) | (18332) | (20475) | (22618) | (24761) | (26904) | (29264) | (32614) |
Sales : internet | 0 | 0 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 |
Stores | 0 | 0 | 2430 | 2430 | 1530 | 1530 | 1530 | 1530 | 1530 | 990 | 0 | 0 |
Cash available | 0 | (8930) | (10173) | (11416) | (13559) | (15702) | (17845) | (19988) | (22131) | (24814) | (28164) | (31514) |
Equipment | 900 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Rental | 7000 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 |
Web page | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 |
Salary | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 |
Others | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 |
Payment for material | 0 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 54 | 20 | 20 | 20 |
Fabric | 0 | 189 | 189 | 189 | 189 | 189 | 189 | 189 | 189 | 70 | 70 | 70 |
Ornament | 270 | 270 | 270 | 270 | 270 | 270 | 270 | 270 | 270 | 100 | 100 | 100 |
Total expense | 8930 | 4773 | 4773 | 4773 | 4773 | 4773 | 4773 | 4773 | 4773 | 4450 | 4450 | 4450 |
Cash flow balance |
(8930) | (13703) | (14946) | (16189) | (18332) | (20475) | (22618) | (24761) | (26904) | (29264) | (32614) | (35964) |
Notes
(1) It is assumed that
(2) Any alternative answer with different assumption is equally correct.
You are starting a new business of Shoes to be sold through internet and specialized stores You c...
MUST SHOW ALL CELL FORMULAS Required: You need to prepare a comprehensive 12-month budget, including supporting schedules and a report for the period January 1, 2020 to December 31, 2020 for Hedron, Inc. INFORMATION FOR HEDRON, INC. Hedron, Inc. is a company that re-sells one product, a particularly comfortable lawn chair. An overseas contractor makes the product exclusively for Hedron, so Hedron has no manufacturing related costs. PRODUCT COSTS In Nov of 2019, each lawn chair costs Hedron $4 per...
IN C++ In a previous assignment you wrote pseudo code for the calculation of the days into a year given the date. Write a function that returns an int. It takes three parameters , all int(s), int DaysIntoYear ( int Year, int Month, int day); The return value is the number of days in the year from January 1 to the specified date. Year is included so you can determine if this is a leap year ( see below). If...
find mape for naive approach S of Quilt covers Bud Bandiscount de March April May and June t store in Carbonde over the past year we shown below Management prepared forecasting a combination of exponential smoothing and its collective judgment for the Sep 95 Oct 110 Nov 120 Dec 119 Jan 92 95 Un sales Management's Forecast Feb 4 - Mar Apr 102 0 120 114 May 90 108 Jun 108 110 a) MAD for the forecast developed by the...
Tony and Suzie graduate from college in May 2021 and begin developing their new business. They begin by offering clinics for basic outdoor activities such as mountain biking or kayaking. Upon developing a customer base, they hold their first adventure races. These races will involve four-person teams that race from one checkpoint to the next using a combination of kayaking, mountain biking, orienteering, and trail running. In the long run, they plan to sell outdoor gear and develop a ropes...
Q2. Draw up a cash budget for Amben Ltd showing the balance at the end of each month from the following information for the six months ended 31 December 2016. Write a short report on the budget. a. Opening cash balance (including bank) balance $12,200 b. Production in units: April 1,240, May 1,270, June 1,300, July 1,320, August 1,350, Sep 1,370, Oct 1,380, Nov 1,340, Dec 1,310, Jan 2017 1,260, Feb, 1,250. c. Raw materials used in production cost $12...
Tony and Suzie graduate from college in May 2021 and begin developing their new business. They begin by offering dinics for basic outdoor activities such as mountain biking or kayaking. Upon developing a customer base, they'll hold their first adventure races. These races will involve four person teams that race from one checkpoint to the next using a combination of kayaking, mountain biking, orienteering, and trail running. In the long run, they plan to sell outdoor gear and develop a...
Key Objective: Crusty Pizza Executives must forecast December sales for the 10 stores in worksheet “Time Series”. Use data in worksheet “Time Series”. Plot the data for each store. Develop a sales forecast for each of the 10 stores for the month of December, using: A three month moving average A 2- month weighted moving average, with weights of 0.7 on the most recent month and 0.3 on the older month. Exponential smoothing with an alpha value of 0.25. Assume...
Tony and Suzie graduate from college in May 2021 and begin developing their new business. They begin by offering dinics for basic outdoor activities such as mountain biking or kayaking. Upon developing a customer base, they'll hold their first adventure races. These races will involve four person teams that race from one checkpoint to the next using a combination of kayaking, mountain biking, orienteering, and trail running. In the long run, they plan to sell outdoor gear and develop a...
Jed Berhad is a manufacturer of Product A and provides the following information for their budgeting purpose. You as an accountant is needed to prepare the budgets for top management review and planning: The opening bank balance was at unfavorable situation of RM 164,000. The company have the plan to produce the following number of unit corresponding with month and year Aug 33,200 Sept 37.400 2019 Oct 41.600 Nov 44,000 Dec 48,000 Jan Feb 52,000 51.200 2020 Apr 42.800 Mar...
Question: Cash Receipts 25% of sales are in cash and collected in the month the sale is made and 75% are on credit and collected in the month after the sale. December 2017 sales were $3 million. The sales forecast for 2018 is as follows: January 2,800,000 February 2,500,000 March 3,200,000 April 3,400,000 May 3,600,000 June 3,600,000 July 3,800,000 August 4,000,000 September 3,600,000 October 3,400,000 November 2,800,000 December 2,600,000 Cash Disbursements The disbursements for this firm are as follows: Payments...