Profit planning model Flying-A Ranch is a former cattle ranch that the owners have converted to an exclusive guest ranch. The ranch offers daily horseback riding, hiking, fishing and just relaxing to a maximum of 14 guests per week. The weekly fee covers costs of all meals, horseback riding and unguided fishing and hiking. A few other ranch activities are offered at modest cost, and guests may contract with other tourist entities for off ranch tours. The table below contains data concerning a typical four month ranch season. Because of its remote location and severe winters, the ranch is closed to guests for the remainder of the year.

Required:.Use the data input to prepare a profit planning model for a typical season.

Transcribed Image Text:

Data input Weeks per month Meals provided per week per guest Double occupancy, rate per week per guest Single occupancy, rate per week per guest 4 21 $ 2000 $ 3000 Guest ranch season June July Double occupancy, guests per week 8 12 August September 12 10 Single occupancy, guests per week 2 1 1 2 Other activities per guest, per week Charge CM ratio Proportion of guests Souvenirs $40.00 50% 80% Flyfishing 10.00 80% 50% Skeet and trap shooting 25.00 40% 20% Off-ranch tours (offered by other entities) 300.00 20% 10% Costs per guest Cabin maintenance per week 50.00 Food cost per meal 10.00 Monthly facility costs Wranglers (3) 6000 Kitchen staff (3) 5000 Cabin maintenance staff (1) 1500 Horses and tack 12000 Maintenance of equipment and vehicles 2500 Utilities 2000 Insurance 3000 Legal and accounting services 2000 Depreciation of buildings, equip. and veh. 5000 Income tax rate 30%