I just want sales budget -budget balance sheet For quarter 1 we can give 5000, quarter 2- 6000 Quarter 3- 5500 Quarter 4- 6500

We need numerical information for our budget. Like sales, variable costs, fixed costs. Steel cable: Vinyl Cover: Number code lock: u can change divide it to be RM15 You can put the answer in excel plz

The first picture, our company, the other two pictures, I want the same, for example

Profile MY-T Name of Company: MY-T Bikesaver Company Logo Product to be sold: Bike lock We provide the best bike lock mechanism designed to endure different levels of thievery with steel cable which affords great versatility due to its flexible nature. Product To Be Sold Raw Materials: Steel cable Vinyl cover Number code lock B E Sales Budget Budgeted sales in unit Selling price per unit D Ending Finished Goods Inventory Budget Ending inventory in unit 8000 50 000 units RM 39.9 Expected Cash Collection Collection pattern Selling & Administrative Expense Budget Variable S&A expense per unit sold Fixed S&A expense RM3 RM 20000 75% collected in the month of sale 25% collected in the month of sale RMO Acc receivable Cash Budget Borrow RM 70000 in the first month Repay in the last month Pay interest 9% in the last month Production Budget Beginning inventory Desired Ending Inventory O unit (for first month) 20% of the following month's budgeted sales Budgeted Income Statement for three months Direct material budget Material needed per unit Material cost per unit Desired ending inventory for material Beginning inventory for material 1 unit of stainless steel cup, 60 gram of epoxy resin RM2 of stainless cup. RM3 per 10gram epoxy resin 10% of the following month's production 0 unit for the first month, following month take previous DEI Direct labor budget Direct labour hours per unit Hourly wage rate 0.05 hours (5 minute) RM10 MOH Budget (MOH is applied on the basis of direct labor hour) Variable MOH rate Fixed MOH Depreciation RM6 per direct labor hour RM 70000 (factory and warehouse=RM50000, truck=RM 20000) no Patel and Company Budgeted Income Statement This Coming Year Ending December 31 Quarter 1 2 3 4 Year $ 148,500 $151,250 $ 170,500 $ 181,500 $651,750 Service revenue* Deduct operating expenses: Manager salaries** Staff salaries*** Administrative staff wages Supplies Rent Utilities Insurance Miscellaneous Total operating expenses Net income (loss) $ 63,000 26,250 11,000 11,500 7,000 2,100 17,500 5,850 $ 144,200 $ 4,300 $ 63,000 38,250 11,000 11,500 7,000 2,100 17,500 5,850 $156,200 $ (4,950) $ 63,000 38,250 11,000 11,500 7,000 2,100 17,500 5,850 $ 156,200 $ 14,300 $ 63,000 38,250 11,000 11,500 7,000 2,100 17,500 5,850 $ 156,200 $ 25,300 $ 252,000 141,000 44,000 46,000 28,000 8,400 70,000 23,400 $612,800 $ 38,950 Profile MY-T Name of Company: MY-T Bikesaver Company Logo Product to be sold: Bike lock We provide the best bike lock mechanism designed to endure different levels of thievery with steel cable which affords great versatility due to its flexible nature. Product To Be Sold Raw Materials: Steel cable Vinyl cover Number code lock B E Sales Budget Budgeted sales in unit Selling price per unit D Ending Finished Goods Inventory Budget Ending inventory in unit 8000 50 000 units RM 39.9 Expected Cash Collection Collection pattern Selling & Administrative Expense Budget Variable S&A expense per unit sold Fixed S&A expense RM3 RM 20000 75% collected in the month of sale 25% collected in the month of sale RMO Acc receivable Cash Budget Borrow RM 70000 in the first month Repay in the last month Pay interest 9% in the last month Production Budget Beginning inventory Desired Ending Inventory O unit (for first month) 20% of the following month's budgeted sales Budgeted Income Statement for three months Direct material budget Material needed per unit Material cost per unit Desired ending inventory for material Beginning inventory for material 1 unit of stainless steel cup, 60 gram of epoxy resin RM2 of stainless cup. RM3 per 10gram epoxy resin 10% of the following month's production 0 unit for the first month, following month take previous DEI Direct labor budget Direct labour hours per unit Hourly wage rate 0.05 hours (5 minute) RM10 MOH Budget (MOH is applied on the basis of direct labor hour) Variable MOH rate Fixed MOH Depreciation RM6 per direct labor hour RM 70000 (factory and warehouse=RM50000, truck=RM 20000) no Patel and Company Budgeted Income Statement This Coming Year Ending December 31 Quarter 1 2 3 4 Year $ 148,500 $151,250 $ 170,500 $ 181,500 $651,750 Service revenue* Deduct operating expenses: Manager salaries** Staff salaries*** Administrative staff wages Supplies Rent Utilities Insurance Miscellaneous Total operating expenses Net income (loss) $ 63,000 26,250 11,000 11,500 7,000 2,100 17,500 5,850 $ 144,200 $ 4,300 $ 63,000 38,250 11,000 11,500 7,000 2,100 17,500 5,850 $156,200 $ (4,950) $ 63,000 38,250 11,000 11,500 7,000 2,100 17,500 5,850 $ 156,200 $ 14,300 $ 63,000 38,250 11,000 11,500 7,000 2,100 17,500 5,850 $ 156,200 $ 25,300 $ 252,000 141,000 44,000 46,000 28,000 8,400 70,000 23,400 $612,800 $ 38,950